Conditional Formatting on Range of Cells

  • Thread starter Thread starter RoadKill
  • Start date Start date
R

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?
 
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.
 
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
 
That is exactly what I have, and unfortunately it doesn't change the color of
the cells at all.
 
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?
 
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.
 
Back
Top