Conditional Formatting on Range of Cells
in [Functions]
|
From: RoadKill on 29 Mar 2010 17:56 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 29 Mar 2010 18:14 >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 29 Mar 2010 18:22 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 29 Mar 2010 18:37 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 29 Mar 2010 18:58
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? > > > . > |