Conditional format icons based on multiple date conditions

**fb2003** · 04-16-2014, 05:39 PM

Hi guys

How could the following conditional formatting be achieved based on these date columns?

Column B = Due date
Column C = icons (red, orange, green) based on combination
Column D = Done date

Combinations:
Red: when today > due date OR done date > due date
Orange: for dates from Today till Today + 2
Green: When Done date is equal or less then due date

See screenshot: Schermafbeelding 2014-04-16 om 23.28.26.png

**:) Sixthsense :)** · 04-17-2014, 12:06 AM

Instead of screenshot please attach a sample workbook.

Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**fb2003** · 04-17-2014, 05:40 AM

Hello Sixthsense

I have attached the workbook. There is a mockup in column E. In Column H, I and J I have defined the formulas separately for each color, which work ok in this separate state. Could this be achieved with conditional formatting in one column?

conditional_format_mockup.xlsx

**:) Sixthsense :)** · 04-17-2014, 06:41 AM

	A	B	C	D
1	Order	Color	Condition	Description
2	1st	Red	>=3	Not done in time. Done date > due date or today > due date
3	2nd	Green	<3	Done in time. Done date equal or less then due date
4	3rd	Yellow	<2	Close to due date. Today till 2 days in future