If then highlite?

S

Steve R

Is there a way to conditional format cells based on other cells?

In other words, is there a way to have cell B5 to turn red if cell A5 has a
number greater than 0?

I just want it to work so when someone enters a quantity in column A, that
the Cost cell highlites in column B to remind them to enter a cost.

THANKS!
 
P

Peo Sjoblom

format>conditional formatting, formula is

=AND(ISNUMBER($A5),$A5>0)

if you know there can never be text in A you can shorten that to

=$A5>0

regards,

Peo Sjoblom
 
Top