Conditional Formatting "Formula Is"

F

fatdaz

All

I am trying to apply conditional formatting to a group of cells using
very simple formula.

In the conditional formatting box I am selecting "Formula Is" and i
the formula box entering:

=IF($T$23="STRING") and applying a format

I get an Excel error "The formula you typed contains an error
complaining about the quotes and the equals signs. The long and th
short of it is that I have to quote the " and = symbols. If I do thi
Excel converts the formula to:

="'=IF($T$23='""STRING'"")"

This is obviously not evaluating correctly as the formatting doesn'
apply.

It almost seems to me like Excel is not accepting this is a formul
even though I am definitely selecting "Formula Is"

Anybody know what's happening here? (Excel 2003 & XP)

Darre
 
T

Tornados

Perhaps you have to add one ',' or a ';' following the conditio
statement in the IF formula..
 
J

Jason Morin

The reason for the error is that your IF statement does
not have enough arguements. In fact, you don't even need
to use IF. Just use:

=$T$23="STRING"

which will evaulate to a TRUE or FALSE.

HTH
Jason
Atlanta, GA
 
T

Trengo

Hi
But if i want two conditions in same cell, formatted in 2 diferent colours when u copy to other cell it assumes the colour of the first one. Is it necessary to make in each cell even the condition is the same for all cells
 
D

David McRitchie

Your English doesn't make sense to me. So I try to pull something
out of a few words or phrases like "2 different colors",
"copy to other cell"..

If you have more than one C.F. formulas, the first one to get the
True condition is the one that is used.

If you want to use .C.F. in many cells it is best to C.F. format them
all at once.

My page on Conditional Formatting is
http://www.mvps.org/dmcritchie/excel/condfmt.htm

HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Trengo said:
Hi,
But if i want two conditions in same cell, formatted in 2 diferent colours when u copy to other cell it assumes the colour of the
Click to expand...
first one. Is it necessary to make in each cell even the condition is the same for all cells?
 
Top