Conditional Formatting - Dates - Icon Sets

[scott_86_]

Hi,

Could anyone help me out with the following?

I have a table with dates that I would like to highlight with shape icon sets (green, red & yellow circles) depending on the date in the cell (see below for an example).

Date format is dd/mm/yy
Blanks cells to remain blank.

Using a formula, I would like to be able to achieve the following (I think I could use the "today" function but not 100% sure):

• Red - any date before today
• Yelllow - any date between today and six months away
• Green - any date over six months

Thanks in advance!

01/09/23​	01/09/22​
01/07/23​	01/07/22​	01/11/21​
01/01/24​	01/01/23​
01/12/23​	01/11/22​
01/05/23​	01/05/22​
		01/01/22​
19/03/23​	01/03/22​

 

[BrianM45]

Hi scott86

Here is an example with MFC, the file is in French, but Excel should translate the formulas (I hope)

GrosFichiers

Fichiers disponibles au téléchargement

www.grosfichiers.com

Regards

 

[scott_86_]

Hi scott86

Here is an example with MFC, the file is in French, but Excel should translate the formulas (I hope)

GrosFichiers

Fichiers disponibles au téléchargement

www.grosfichiers.com

Regards

Hi Brian, thanks for your reply.

Unfortunatly Excel did not allow me to allow that CF formula to an icon set.

 

[BrianM45]

Sorry, I forgot this part of the request

You have the formulas, all that remains is to find a solution for the icons

Just kidding, but for me it's not doable

 

[scott_86_]

Sorry, I forgot this part of the request

You have the formulas, all that remains is to find a solution for the icons

Just kidding, but for me it's not doable

All good, thanks.

I think I figured it out. See image below.