How do I use cond format formula to set cell text and color?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using MS Excel 2003:

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

I'm expecting cell B1 to display, "Test" 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="" and put a seperate if
statement in the cell.If it blank test will be red
 
Using MS Excel 2003:

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

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

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=""
 
What if you change formula in B1's Formula Is to =A1 =""
Then, when A1 is blank B1 will adopt the yellow fill and red font
color.
Ken Johnson
 
Back
Top