I have another issue with conditional formatting in my excel report. I realized after posting on this thread and getting a response that solved the report to, I now realize, a point.
There are two conditions I need to meet that involves Column F, Days Until Due and Column E, Ball In Court...
Where John Smith's name shows up in Column E, whether singly or with other names present (i.e. cell rows 2, 3, 4, 6) and the Column F numbers are 1 or greater, the whole cell row needs to be green.
Where names other than John Smith's appear and the Column F numbers are 1 or greater, the whole cell needs to have no fill.
I've been pulling my hair out trying to configure the formula using AND, IF, THEN, etc. and could use some help here.
FYI - The conditional formatting in these rows is back to it's simplest format.
Thank you in advance!
DCnyc
Bookmarks