Forum Discussion
Solved
@Excel @2016 @IF Function; help removing conditional formatting until cell has data
I am very new at Excel formulas, learning as I go. I am attempting to include an IF Function that will only include data when other cells have data (see attached). I have figured it out, however th...
=AND(D35>30,C35<>"")
If i correctly understand what you want to do you can apply above rule for conditional formatting. I deleted all rules for conditional formatting in the original file (some of these rules are for column D as well) and focused on a possible solution and it works in my spreadsheet for range D35:D50.
=AND(D35>30,C35<>"")
If i correctly understand what you want to do you can apply above rule for conditional formatting. I deleted all rules for conditional formatting in the original file (some of these rules are for column D as well) and focused on a possible solution and it works in my spreadsheet for range D35:D50.