excel conditional formatting
in [Functions]
|
Prev: Help? with extracting unsorted data from a worksheet, no blank
Next: How to convert 115:14 into hours? ( 115 stands for hrs, 14 is minu
From: Vic on 30 Mar 2010 19:18 I need to write a conditional formula that will result in a highlight of the cell if the cell value is not one of these three "yes", "no", or "N/A". Can't get it to work. Can anyone help me. -- Vic
From: Nadine on 30 Mar 2010 20:01 The first two are: Condition 1: Cell value is equal to ="Yes" Click Add at the bottom of the dialog box Condition 2: Cell value is equal to ="No" Choose the format for each one as you want them to be. Maybe someone else can help with the #N/A piece of this. Nadine "Vic" wrote: > I need to write a conditional formula that will result in a highlight of the > cell if the cell value is not one of these three "yes", "no", or "N/A". > Can't get it to work. Can anyone help me. > -- > Vic
From: Fred Smith on 30 Mar 2010 20:48 =and(a1<>"yes",a1<>"no",a1<>"N/A") Regards, Fred "Vic" <Vic(a)discussions.microsoft.com> wrote in message news:ACCFFD92-535B-4B22-8FAA-17CE49DEEE62(a)microsoft.com... >I need to write a conditional formula that will result in a highlight of >the > cell if the cell value is not one of these three "yes", "no", or "N/A". > Can't get it to work. Can anyone help me. > -- > Vic
From: Vic on 1 Apr 2010 08:10 Fred worked like a charm thank you so much!!!! -- Vic "Fred Smith" wrote: > =and(a1<>"yes",a1<>"no",a1<>"N/A") > > Regards, > Fred > > "Vic" <Vic(a)discussions.microsoft.com> wrote in message > news:ACCFFD92-535B-4B22-8FAA-17CE49DEEE62(a)microsoft.com... > >I need to write a conditional formula that will result in a highlight of > >the > > cell if the cell value is not one of these three "yes", "no", or "N/A". > > Can't get it to work. Can anyone help me. > > -- > > Vic > > . >
From: Fred Smith on 1 Apr 2010 08:50
You're welcome. Thanks for the feedback. Fred. "Vic" <Vic(a)discussions.microsoft.com> wrote in message news:E13551F7-82F9-43F7-B800-CF8A5A39AC4A(a)microsoft.com... > Fred worked like a charm thank you so much!!!! > -- > Vic > > > "Fred Smith" wrote: > >> =and(a1<>"yes",a1<>"no",a1<>"N/A") >> >> Regards, >> Fred >> >> "Vic" <Vic(a)discussions.microsoft.com> wrote in message >> news:ACCFFD92-535B-4B22-8FAA-17CE49DEEE62(a)microsoft.com... >> >I need to write a conditional formula that will result in a highlight of >> >the >> > cell if the cell value is not one of these three "yes", "no", or "N/A". >> > Can't get it to work. Can anyone help me. >> > -- >> > Vic >> >> . >> |