Hi,

I have to monitor many clients and be able to order the data based on when they were referred in from oldest to newest. But in addition, I would like to make them RED, AMBER or GREEN based on how old they are against the current date (ie today).

EG;

– More than 2 days old = GREEN

– More than 3 days old = AMBER

– More than 5 days old = RED

Can someone tell me the formula I should use, or how I can set the rules under conditional formatting?

Thanks

​Hi,I have to monitor many clients and be able to order the data based on when they were referred in from oldest to newest. But in addition, I would like to make them RED, AMBER or GREEN based on how old they are against the current date (ie today).EG;- More than 2 days old = GREEN- More than 3 days old = AMBER- More than 5 days old = REDCan someone tell me the formula I should use, or how I can set the rules under conditional formatting? Thanks  Read More

​