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

Set up the condition as follows:

Cell Value Is
not equal to
=""

What are you using in Conditional Formatting?

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

try

=A1=""


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=508701

Once again I am humbled by the simpliity. Many thanks.

Graham

wrote:
Set up the condition as follows:

Cell Value Is
not equal to
=""

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


daddylonglegs wrote:

What are you using in Conditional Formatting?

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

try

=A1=""