software

Using MS Excel 2003:

As and example, I entered into Conditional Format for cell B1:
quot;Formula isquot;, IF(A1=quot;quot;,quot;Testquot;,quot;quot;). For true condition, the format is set to
fill Yellow and font color red.

I'm expecting cell B1 to display, quot;Testquot; in red text with yellow background
when A1 is blank, but it does not work. No errors are displayed. Any ideas?

in my experience you can only set the format,you cant have the word test show
up.Apply the format condition only using =A1=quot;quot; and put a seperate if
statement in the cell.If it blank test will be red
--
paul
remove nospam for email addy!
quot;sbwilliamsquot; wrote:

gt; Using MS Excel 2003:
gt;
gt; As and example, I entered into Conditional Format for cell B1:
gt; quot;Formula isquot;, IF(A1=quot;quot;,quot;Testquot;,quot;quot;). For true condition, the format is set to
gt; fill Yellow and font color red.
gt;
gt; I'm expecting cell B1 to display, quot;Testquot; in red text with yellow background
gt; when A1 is blank, but it does not work. No errors are displayed. Any ideas?

On Sat, 7 Jan 2006 14:00:02 -0800, quot;sbwilliamsquot;
gt; wrote:

gt;Using MS Excel 2003:
gt;
gt;As and example, I entered into Conditional Format for cell B1:
gt;quot;Formula isquot;, IF(A1=quot;quot;,quot;Testquot;,quot;quot;). For true condition, the format is set to
gt;fill Yellow and font color red.
gt;
gt;I'm expecting cell B1 to display, quot;Testquot; in red text with yellow background
gt;when A1 is blank, but it does not work. No errors are displayed. Any ideas?

You're doing it wrong.

Put your formula in cell B1.

For your conditional format:

Cell Value Is Equal To: Test--ron

Hi

Your formula for B1 is fine.
For Conditional Format, all you require is =A1=quot;quot;

--
Regards

Roger Govierquot;sbwilliamsquot; gt; wrote in message
...
gt; Using MS Excel 2003:
gt;
gt; As and example, I entered into Conditional Format for cell B1:
gt; quot;Formula isquot;, IF(A1=quot;quot;,quot;Testquot;,quot;quot;). For true condition, the format is
gt; set to
gt; fill Yellow and font color red.
gt;
gt; I'm expecting cell B1 to display, quot;Testquot; in red text with yellow
gt; background
gt; when A1 is blank, but it does not work. No errors are displayed. Any
gt; ideas?
What if you change formula in B1's Formula Is to =A1 =quot;quot;
Then, when A1 is blank B1 will adopt the yellow fill and red font
color.
Ken Johnson