Conditional Formating

  • Thread starter Thread starter Bob
  • Start date Start date
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
 
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:
 
sorry for the mistake use <=0 instead of >=0

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



"Marcelo" escreveu:
 
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...
 
Back
Top