software

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 quot;blankquot; 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
=quot;quot;
What are you using in Conditional Formatting?

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

try

=A1=quot;quot;--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=508701
Once again I am humbled by the simpliity. Many thanks.

Graham
wrote:
gt; Set up the condition as follows:
gt;
gt; Cell Value Is
gt; not equal to
gt; =quot;quot;
gt;

Following last posting I entered =quot;quot; into conditional format and it
worked fine. Thanks for help.daddylonglegs wrote:

gt; What are you using in Conditional Formatting?
gt;
gt; =ISBLANK(A1) won't work if you have a formula that returns quot;quot;
gt;
gt; try
gt;
gt; =A1=quot;quot;
gt;
gt;