Conditional format column with all cells containg formulas. Highlight cells in this column

[Rollason]

Conditional format column with all cells containing formulas.
Highlight cells in this column with calculated values between 0 and 30 only.
When I do it blank cells get highlighted too because they still have a formula in it.

Thanks

[6StringJazzer]

Did you try

Please Login or Register  to view this content.

[Rollason]

Hi Jeff
No I didnt. Have now, still colours up a cell whose value is zero becuase the cell has a formula in it (which produces zero) trying to avoid that.
Thanks

[6StringJazzer]

You said:

Highlight cells in this column with calculated values between 0 and 30 only.

Between inclusively, or between exclusively?

If you don't want to include 0 then just change => to >.