Conditional Formatting on Range of Cells
in [Functions]
|
From: Max on 29 Mar 2010 19:11 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.
From: Nadine on 29 Mar 2010 20:36 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?
From: T. Valko on 29 Mar 2010 21:23
See if this might be the culprit: http://support.microsoft.com/?id=833258 -- Biff Microsoft Excel MVP "RoadKill" <RoadKill(a)discussions.microsoft.com> wrote in message news:7D95B90B-F8B4-4DA6-BE09-78FDEF56A644(a)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(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? >> >> >> . >> |