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!

formatconditional formatting, formula is

=AND(ISNUMBER($A5),$A50)

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

=$A50

regards,

Peo Sjoblom

"Steve R" wrote:

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!