 SOLVED

New Contributor

@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 the formatting that applies when a file's age is greater than 30 appears.  I would like to have the formula in the cell without the conditional formatting UNTIL data is entered in the adjacent cells.

My issue is with Column D where the formula is; where if C35 is bland, then it will remain blank.  Otherwise, it will do one of two things, either calculate the net working days between date of receipt (E) and Today's date (F) or net working days between Date of receipt (E)and Date of decision (Z) :

=IF(C35="","",IF(Z35="",NETWORKDAYS(E35,F35),NETWORKDAYS(E35,Z35)))

The conditional formatting applicable to column D provides for pink background and wine colored font, is:

Format only cells that contain, Cell Value, Greater than, =30

I have attempted some suggestions from online forums unsuccessfully.

ex.: Use a formula to determine which cells to format; = ISBLANK(D2)=TRUE, with no Format Set, applicable from D2:D50

Tried these as well, unsuccessfully :

=IF(Z2=ISBLANK(D2),NETWORKDAYS(E34,F34),NETWORKDAYS(E34,Z34))

=IF(Z34=ISBLANK(Z34),NETWORKDAYS(E34,F34),NETWORKDAYS(E34,Z34))

=IF((C34="","",TODAY())(Z34=ISBLANK(Z34),NETWORKDAYS(E34,F34),NETWORKDAYS(E34,Z34)))

=IFS(C34="","",NETWORKDAYS(E34,F34))(Z34="",NETWORKDAYS(E34,F34),NETWORKDAYS(E34,Z34))