Excel 2013, Windows 7 Pro. I have a spreadsheet with some Conditional formatting, but I need multiple rules & I don't know how to make them work correctly together.
1) First, I want one specific cell filled with Orange if another specific cell in that row contains "YES".
2) Once data is later entered into the Orange cell, the Orange fill color should be removed and -
3) If the data entered in that cell doesn't exactly match the contents of another specific cell in the same row, change fill color to RED.
I've been able to set up 1 & 3, but I don't know how to remove the Orange fill in #2 once I've input data in that cell. What I currently have "works" but not well, since rules 1 & 3 are in conflict with each other. If I make a change to either rule & select "Apply", Excel says "Cannot make changes to the conditional formatting".