conditional formatting

  • Thread starter Thread starter greg
  • Start date Start date
G

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
 
Hi
try
- select cell A1
- goto the conditional Format dialog and choose 'Formula'. enter the
formula
=B1=0
choose a format
 
Back
Top