See if this might be the culprit:

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

--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
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?

"T. Valko" wrote:

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.

--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
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?


.