• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Conditional format to track Status against Due date

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
 
Hi ,

Top-most rule formula : =AND($C2 = "" , $B2 < TODAY()) , RED

Second rule formula : =AND($C2 = "" , ($B2<= TODAY() + 10)) , YELLOW

Third rule formula : =AND($C2 <> "" , $C2 <= $B2) , GREEN

Fourth rule formula : =$C2 > $B2 , RED

Change the row reference to suit. The above formulae have been used to conditionally format cell D2.

Narayan
 
Back
Top