Conditional Formatting on Range of Cells
 

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?

Conditional Formatting on Range of Cells
 

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?

Conditional Formatting on Range of Cells
 

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?

Conditional Formatting on Range of Cells
 

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?

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?


.

Conditional Formatting on Range of Cells
 

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.

Conditional Formatting on Range of Cells
 

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?

Conditional Formatting on Range of Cells
 

See if this might be the culprit:

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

--
Biff
Microsoft Excel MVP


"RoadKill" wrote in message
...
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?


.