Excel IF Statement, Conditional Formatting Failure
I hope this will be easy. I am making a mistake, or missing something.
The Conditional Formatting formula changes the output in cell $G$19, based on the value in cell E20.
The formula is:
=IF((E20="NO"),("Delete Flat Rate Below"),IF(E20="YES"),("Enter Flat Rate Below"), "")
Applies to: $G$19