View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
roadkill roadkill is offline
external usenet poster
 
Posts: 173
Default 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?



.