Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

may be just make the range for conditional formatting larger than now there are values and for empty cell needs to make additional condition:

Cell value is - equal to - "" with style - Default

and move it to top in list

in this case your condition will work how you wrote