Hi,
Does nested OR() work?
I need some help with a formula for conditional formatting which should satisfy three conditions. The hitch is two of those conditions should be clubbed as Condition 1 and the third should stand as Conditon 2. It goes something like this:
If [Today<=Date1 & (Condition A OR ConditionB)] is true, OR if Condition C is true, then Format X.
My efforts:
=OR((TODAY()<=$H$25, AND(OR($F$25="A", $F$25="B"))), $F$25="C")
=IF(OR((TODAY()<=$H$26, AND(OR($F$26="A", $F$26="B")))), $F$26="C")
Something is not just right in there. Some quick suggestions please?
Thanks!
Does nested OR() work?
I need some help with a formula for conditional formatting which should satisfy three conditions. The hitch is two of those conditions should be clubbed as Condition 1 and the third should stand as Conditon 2. It goes something like this:
If [Today<=Date1 & (Condition A OR ConditionB)] is true, OR if Condition C is true, then Format X.
My efforts:
=OR((TODAY()<=$H$25, AND(OR($F$25="A", $F$25="B"))), $F$25="C")
=IF(OR((TODAY()<=$H$26, AND(OR($F$26="A", $F$26="B")))), $F$26="C")
Something is not just right in there. Some quick suggestions please?
Thanks!