Conditional Format to indentify an empty cell

  • Thread starter Thread starter Christopher
  • Start date Start date
C

Christopher

Hi,
I have a range of data in which i want to shade all cells
which are empty. However, many of the cells contain 0.0
and i do not want these cells to be shaded. All of the
conditional formats i've tried (ie. any value, less than
0) seems to include the 0.0 cells. is there a way i can
define no value in a conditional format, or is there
another function i could be using?
thanks for your help.

chris
 
PERFECT!!!!
Thank you very much Frank


-----Original Message-----
Hi
try the formula
=A1=""

in your conditional format dialog for cell A1


--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
Back
Top