conditional format

orsm6

Board Regular
Joined
Oct 3, 2012
Messages
149
Hi my conditional format is not working and i can't figure out why. i think i have looked at this too much lol.

my conditional format formula is: =OR($B18>””,$B18>0)
the cell range it is applied to is: =$B$16,$D$16,$F$16,$H$16,$J$16

B18 only ever has a date entered into it if that helps, i was just trying to cover all bases with formula.

but when i type a date or a number into B18 nothing changes. (the cond format is to grey the box out in colour, border and font colour)

where am i going wrong? TIA
 

Forum statistics

Threads
1,077,991
Messages
5,337,591
Members
399,156
Latest member
RaudMees

Some videos you may like

This Week's Hot Topics

Top