Cnditional Formatting for past dates using ICONS

[Mark24931816]

Good morning

I have a 3 year training cycle and have been trying to use the "ICON SET" Red, Amber, Green flags in boxes alongside the date to highlight as follows

Red when the training is out of date or past 1065 days from today's date so have tried =TODAY()-1065 in the formula box

Amber to give a 30 day warning prior to expiry so have tried =TODAY()-1035 for the Amber box

And the green flag should automatically set itself for as the condition for anything within them boundaries

it just doesn't seem to stick or I am missing something

any guidance grateful received and understand it is probably easy for some of you

regards

Mark

 

[tyija1995]

Hey,

So with the icon set flags, when you go to put in the values use this setup:

Icon: green flag
Equality: >
Value: =TODAY()-1035
Type: Formula

Icon: orange flag
Equality: >=
Value: =TODAY()-1065
Type: Formula

Icon: red flag

Do in that order - green -> orange -> red (top to bottom)

 

[Mark24931816]

Many thanks for your input, all sorted, i had the amber and red the wrong way round !