Jun 29 2019 04:09 PM
Hi - Im trying to apply conditional formatting to Column W if the following:
If AF1="Closed" then change cell colour to RED
IF H1="P" and N1>O1 and W1<1 then change cell colour to Yellow
IF H1="C" and O1>N1 and W1<1 then change cell colour to Yellow
Thanks.
Jun 29 2019 10:59 PM
Solution
1) Select all of Column W
2) select new rule in the conditional formatting options and select the option to use formulas to format
3) Type in: =AF1="Closed", select the fill colour in the format options to be red and click OK
4) Select column W, New Rule and the option to use formulas to format again
5) Type in: =OR(AND(H1="P", N1>O1, W1<1), AND(H1="C", O1>N1, W1<1)) and select the fill colour in the format options to be Yellow. Then Click OK
Jun 29 2019 10:59 PM
Solution
1) Select all of Column W
2) select new rule in the conditional formatting options and select the option to use formulas to format
3) Type in: =AF1="Closed", select the fill colour in the format options to be red and click OK
4) Select column W, New Rule and the option to use formulas to format again
5) Type in: =OR(AND(H1="P", N1>O1, W1<1), AND(H1="C", O1>N1, W1<1)) and select the fill colour in the format options to be Yellow. Then Click OK