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

Excel VBA 1
Can I do a conditional formatting on a cell that is not the same w 4
conditional formating 1
conditional formating for the whole row, based on one cell value 2
Conditional Formating on Several Cells 6
Conditional Formating 13
Conditional formating 3
Excel 2007 Conditional Font Color How To? 1

Top