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.

-- 
Biff
Microsoft Excel MVP


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

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?

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?

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@discussions.microsoft.com> wrote in message 
> news:5FE47576-DF03-4CE5-8536-51C4CDA1A2B7@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? 
> 
> 
> .
> 

How about using TRIM?
=TRIM($N$23)="F"
-- 
Max
Singapore
--- 
"RoadKill" wrote:
> .. and unfortunately it doesn't change the color of the cells at all.

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.


"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?

See if this might be the culprit:

http://support.microsoft.com/?id=833258

-- 
Biff
Microsoft Excel MVP


"RoadKill" <RoadKill@discussions.microsoft.com> wrote in message 
news:7D95B90B-F8B4-4DA6-BE09-78FDEF56A644@microsoft.com...
> 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@discussions.microsoft.com> wrote in message
>> news:5FE47576-DF03-4CE5-8536-51C4CDA1A2B7@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?
>>
>>
>> .
>>