Conditional Formatting on Range of Cells
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?
.
|