Conditional Formatting - stuck on formula
in [Functions]
|
Prev: filtering subtotals and if functions
Next: Excel Formulas not duplicating to the next Cell, copying the valueinstead.
From: Awrex on 3 May 2010 15:57 Hi - Thanks beforehand! I'm stuck on a formula for a condition and hoping someone can help. =AND($H23="stalled",$G23<>TODAY()) Is currently what I have and it works... I need to add an additional part to this formula that looks for if $G23 is blank and/or if it's past today(). So if it's "stalled" has no date or the date has not occurred then true, else if "stalled" and has date that has occurred then false.
From: Fred Smith on 3 May 2010 16:03 Try: =AND($H23="stalled",OR($G23="",$G23>TODAY())) Regards, Fred "Awrex" <Awrex(a)discussions.microsoft.com> wrote in message news:ABA98B3A-57BA-48B6-AEA1-44F87861F3E0(a)microsoft.com... > Hi - Thanks beforehand! > > I'm stuck on a formula for a condition and hoping someone can help. > > =AND($H23="stalled",$G23<>TODAY()) > > Is currently what I have and it works... I need to add an additional part > to > this formula that looks for if $G23 is blank and/or if it's past today(). > > So if it's "stalled" has no date or the date has not occurred then true, > else if "stalled" and has date that has occurred then false.
From: Awrex on 3 May 2010 16:54 Perfect thanks!!! "Fred Smith" wrote: > Try: > =AND($H23="stalled",OR($G23="",$G23>TODAY())) > > Regards, > Fred > > > "Awrex" <Awrex(a)discussions.microsoft.com> wrote in message > news:ABA98B3A-57BA-48B6-AEA1-44F87861F3E0(a)microsoft.com... > > Hi - Thanks beforehand! > > > > I'm stuck on a formula for a condition and hoping someone can help. > > > > =AND($H23="stalled",$G23<>TODAY()) > > > > Is currently what I have and it works... I need to add an additional part > > to > > this formula that looks for if $G23 is blank and/or if it's past today(). > > > > So if it's "stalled" has no date or the date has not occurred then true, > > else if "stalled" and has date that has occurred then false. > > . >
From: Fred Smith on 3 May 2010 18:48
You're welcome. Thanks for the feedback. Fred. "Awrex" <Awrex(a)discussions.microsoft.com> wrote in message news:A25A3462-8F7A-4BBB-B104-9E7A1E31726D(a)microsoft.com... > Perfect thanks!!! > > "Fred Smith" wrote: > >> Try: >> =AND($H23="stalled",OR($G23="",$G23>TODAY())) >> >> Regards, >> Fred >> >> >> "Awrex" <Awrex(a)discussions.microsoft.com> wrote in message >> news:ABA98B3A-57BA-48B6-AEA1-44F87861F3E0(a)microsoft.com... >> > Hi - Thanks beforehand! >> > >> > I'm stuck on a formula for a condition and hoping someone can help. >> > >> > =AND($H23="stalled",$G23<>TODAY()) >> > >> > Is currently what I have and it works... I need to add an additional >> > part >> > to >> > this formula that looks for if $G23 is blank and/or if it's past >> > today(). >> > >> > So if it's "stalled" has no date or the date has not occurred then >> > true, >> > else if "stalled" and has date that has occurred then false. >> >> . >> |