Conditional Format to indentify an empty cell

[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

 

[Frank Kabel]

Hi
try the formula
=A1=""

in your conditional format dialog for cell A1

 

[Christopher]

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


.