craigs23
New Member
I am trying to put together a summary sheet which will be a visual indicator to show task status against due date.
Scenario:
Cell A1 = Issue date
Cell B1 = Due date (A1 +15)
Cell C1 = Date completed
In cell D1:
If Cell C1 is empty and B1 > 10 days away = No Fill
If Cell C1 is empty and B1 < 10 days away = Fill yellow
If Cell C1 is empty and today is greater than B1 = fill red
If Cell C1 date is = or < Than B1 then D1 Fill Green
If Cell C1 date is > B1 then D1 Fill Red
I cannot seem to get conditional formatting to work for all scenario's
I am hoping some 'Fresh Eyes' in the form of the helpful people here may be able to offer some assistance
Thanks in advance
Scenario:
Cell A1 = Issue date
Cell B1 = Due date (A1 +15)
Cell C1 = Date completed
In cell D1:
If Cell C1 is empty and B1 > 10 days away = No Fill
If Cell C1 is empty and B1 < 10 days away = Fill yellow
If Cell C1 is empty and today is greater than B1 = fill red
If Cell C1 date is = or < Than B1 then D1 Fill Green
If Cell C1 date is > B1 then D1 Fill Red
I cannot seem to get conditional formatting to work for all scenario's
I am hoping some 'Fresh Eyes' in the form of the helpful people here may be able to offer some assistance
Thanks in advance