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"),("En
Applies to: $G$19
Any assistance or insight would be appreciated.
Tosagua
Conditional-Formatiing-Formula.xlsx
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"),("En
Applies to: $G$19
Any assistance or insight would be appreciated.
Tosagua
Conditional-Formatiing-Formula.xlsx
Microsoft Excel
Last Comment
Professor J
why you have merged cells? should it be merged?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Also, your formula should be:
=IF(E20="NO", "Delete Flat Rate Below", IF(E20="YES", "Enter Flat Rate Below", ""))
please find attached.
EE.xlsx
EE.xlsx
ASKER
Shaun,
Duh. I do not know what I was thinking.
Thank you for your kind assistance and quick response.
Tosagua
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.
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.