I wonder if someone would be able to help me with this. This is probably really simple, but I can't get it to work. I need excel to change a cell to red if the due date on that cell is before today's date (date on that cell will change based on the date that is input on another cell), but only if the cell next to it has been left blank.
So if cell G2 has had a comment written on it, then cell H2 should be clear, regardless of the due date. If G2 has been left blank then H2 should be red if today is past the date on the cell. Hope that makes sense.
I've used this formula to determine if cell is past due date =$H$2<TODAY() and it would format the cell red.
So, are you asking about conditional formatting, or how to nest different logic statements?
With your example, it looks like you can do the conditional formatting.
You can have a list of lets say 10+ different logic tests to return a true with Conditional formatting. Just stack the logic from least to most significant. In other words, every single logic test can make a formatting change to the cell! It is the last "True" logic test that wins!
It's kind of fun to do the impossible! -Walter Elias Disney