conditional formatting

[greg]

I have a question about conditional formatting.
Can I format a cell say A1 when cell B1 is "0"?
so if B1 = 0 then A1 I can make the text red or bold, etc...

thanks in advance

 

[Frank Kabel]

Hi
try
- select cell A1
- goto the conditional Format dialog and choose 'Formula'. enter the
formula
=B1=0
choose a format

 

[greg]

thanks, that works

Hi
try
- select cell A1
- goto the conditional Format dialog and choose 'Formula'. enter the
formula
=B1=0
choose a format