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?