Conditional Formating
sorry for the mistake use <=0 instead of =0
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Marcelo" escreveu:
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
|