Conditional Formatting with Colors

[msawicki]

I'm trying to apply conditional formatting into columns with dates into date fields that show red yellow andgreen; if not complete AND date not passed = green; if not complete and date1-10 days late yellow; if not complete and 11+ days late = Red

For example, if column A has a date of 11/30/2017 and column B has a date of 9/30/2017, I'd like to turn column A red. If column B were to say 11/22/2017, I would like to turn column A yellow. If column B says 12/15/2017, I'd like to turn Column A green.

thanks

 

[Little_Clubber]

Hi msawicki,
I could not tell from your question how to determine if your task is complete / not complete, but the below conditional formatting suits your colour scheme requirements.
Please let me know if this fixes your issue or not and I'll have another go if needed.

 

[Little_Clubber]

I've only just noticed my picture didn't import to you. Have you resolved your issue? Woudl you like to send me your file and I'll put the conditional formatting on?

 

[jtakw]

Rule #4 : https://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html