From: RoadKill on
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?
From: T. Valko on
>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" <RoadKill(a)discussions.microsoft.com> wrote in message
news:5FE47576-DF03-4CE5-8536-51C4CDA1A2B7(a)microsoft.com...
> 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?


From: FSt1 on
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

"RoadKill" wrote:

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

"FSt1" wrote:

> 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
>
> "RoadKill" wrote:
>
> > 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?
From: RoadKill on
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" <RoadKill(a)discussions.microsoft.com> wrote in message
> news:5FE47576-DF03-4CE5-8536-51C4CDA1A2B7(a)microsoft.com...
> > 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?
>
>
> .
>