Conditional Formatting based on values in two cells
Hi,
I have written formulas to add fill to cells based on distance out from a future date (i.e. at >90 days, 90-61, 60-31, and 30-0 days out from future date fill green, yellow, orange, or red). (See image)
This works fine, but I'd like to add to the formula so that if a cell on the same row in a different column has any date entered into it, no conditional formatting is applied. Said another way, if my conditional formatting is in E2, and any date is entered in G2, it would override the conditional formatting and no color is applied.
Also, Excel defaulted to including an AND statement in the 2nd, 3rd, and 4th condition. I guess I'm just not clear why that's appropriate since the conditions are all independent of each other and cannot exist at the same time, though I understand why the OR statement is also not appropriate.
Thanks,
Henry
|