Conditional Formatting on Range of Cells

[RoadKill]

My Range is A23:M:23. I want these to be a color if the contents of N23 is F.

I have tried, =$N$23="F" as well as =$N$23=F without any luck.

Any suggestions?

 

[T. Valko]

I have tried, =$N$23="F"

That's the formula you would want to use.

Enter that formula in a worksheet cell. What result do you get? It may be
that N23 does contain F but it might also contain unseen whitespace
characters so that something like this:

F<space>

Would cause =$N$23="F" to return FALSE.

 

[FSt1]

hi
select A23:M23
set CF for all cell in selected range at once....
formula is.....=$N$23="F".....pick your color.
type F in N23. the rangeA23:M23 should change to picked color.

Regards
FSt1

 

[RoadKill]

That is exactly what I have, and unfortunately it doesn't change the color of
the cells at all.

 

[RoadKill]

There isn't any whitespace. I have even tried it on a new, blank worksheet
using basic numbers. Nothing happens.

Is there some setting that would prevent it?

 

[Max]

How about using TRIM?
=TRIM($N$23)="F"

 

[Nadine]

Select cells A23 through M23. Go to Conditional Formatting and choose Cell
Value Is Equal To and type in =$N$23 and choose how you want the cell
formatted and click OK.
Now enter an F in cell N23 and it should change the color of any cell with
an F in it in the range A23:M23.

Do not use =$N$23=F with or without quotes.

 

[T. Valko]

See if this might be the culprit:

http://support.microsoft.com/?id=833258