The conditional formatting applicable to column D provides for pink background and wine colored font, is:įormat only cells that contain, Cell Value, Greater than, =30 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) : My issue is with Column D where the formula is where if C35 is bland, then it will remain blank. I would like to have the formula in the cell without the conditional formatting UNTIL data is entered in the adjacent cells. I have figured it out, however the formatting that applies when a file's age is greater than 30 appears. I am attempting to include an IF Function that will only include data when other cells have data (see attached). I am very new at Excel formulas, learning as I go.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |