Conditional Format

G

Graham Haughs

Is it possible to set a conditional format in a cell which has a formula
so that when a value appears in that cell, the cell background changes
colour. When there is no value the default colour should remain as the
formula returns a "blank" value. When I try it the conditional format
assumes the formula is a value and shows a colour.
Value any assistance.

Graham
Turriff, Scotland
 
D

daddylonglegs

What are you using in Conditional Formatting?

=ISBLANK(A1) won't work if you have a formula that returns ""

try

=A1="
 
G

Graham Haughs

Following last posting I entered ="" into conditional format and it
worked fine. Thanks for help.
 
Top