View Single Post
  #1   Report Post  
Steve R
 
Posts: n/a
Default If then highlite?

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!