Conditional Formating
 

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

Conditional Formating
 

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

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

Conditional Formating
 

Thanks works like a champ...

Bob

"Marcelo" wrote:

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