conditional formatting

  • Thread starter Thread starter Tflight
  • Start date Start date
T

Tflight

Hi,

I am wanting to make one cell turn a certain color when another cell in that
row is greater than 0. I understand that I should go to Format, Conditional
Formatting, and then Formula Is, but I'm not sure what to do after that.

Formula Is =COUNTIF(G6:G327,">0") but nothing happens....
 
Hi
Not sure if this is what you want.
This formula =OR($A3:$A45>0) will turn colour if any cells are >0
=AND($A33:$A45>0) this one all the cell have to be >0
HTH
John
 
Back
Top