Conditional Formating

B

Bob

Excell 2003.

If the results in "Say" cell Q12 is <= 0 then B12:Q12 all of the text turns
red or the background cell color changes to grey...

Conditional formation is great but when there is a loto of columns I get
lost looking for the data in the first column when the data in the last
column is the one that has the conditional formating.

Many thanks in advance

Bob
 
M

Marcelo

Slect the range b12:q12.

Foarmat > Conditional Format > change to the formula is on the drop down
botton, and type =$Q$12>=0

format as you need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Bob" escreveu:
 
M

Marcelo

sorry for the mistake use <=0 instead of >=0

--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Marcelo" escreveu:
 
B

Bob

Thanks works like a champ...

Bob

Marcelo said:
Slect the range b12:q12.

Foarmat > Conditional Format > change to the formula is on the drop down
botton, and type =$Q$12>=0

format as you need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Bob" escreveu:
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with dates 7
Conditional formatting disappears when cell contents deleted 2
Cobditional Formatting Rows based on dates in action plan. 0
Conditional Formatting Dates Less Than 14 Years Ago 2
Help with Sumproduct searching cell contents 2
Conditional Format Entire Workbook 1
Conditional Formatting with VBA 4
Conditional formatting with two columns 0

Top