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:

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