Link to home
Start Free TrialLog in
Avatar of Tosagua
Tosagua

asked on

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

Any assistance or insight would be appreciated.

Tosagua
Conditional-Formatiing-Formula.xlsx
Avatar of Professor J
Professor J

why you have merged cells?  should it be merged?
ASKER CERTIFIED SOLUTION
Avatar of Shaun Kline
Shaun Kline
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Also, your formula should be:
=IF(E20="NO", "Delete Flat Rate Below", IF(E20="YES", "Enter Flat Rate Below", ""))

Open in new window

please find attached.
EE.xlsx
Avatar of Tosagua

ASKER

Shaun,

Duh. I do not know what I was thinking.

Thank you for your kind assistance and quick response.

Tosagua
Tosagua

may you were thinking to change the format cell color with the conditional formatting , the way it is in the attached workbook in my earlier post.