Conditional formatting to RAG rate based on dates

I have a column that holds a date (F2). This is the "received" date. Then i have another column (I2) that i work out and input a "target" date that is 20 working days after that in F2. What i want is when I2 is between 0 - 10 working days from F2 to be green, 11 - 20 working days to be amber, and when it's 21 days and over, to be red. Does that make sense?

Obviously i would like the "fill" to be rag rated, not the font, but i don't know how to do that on here :smile:
Many thanks in advance.
Debbie.

Hello
what is RAG rate please?

Hello. Sorry, it's RED, AMBER, GREEN.

DebsTurner said:

Obviously i would like the "fill" to be rag rated, not the font

Click to expand...

If you had been set an example with the expected result, it would probably be clearer.
Try Conditional Formatting
GREEN
AMBER
RED

Hi Debs
You can try Conditional Formatting
e.g.

=I2-F2>=21 for RED
=AND(I2-F2>=11,I2-F2<=20) for AMBER
=I2-F2<=10 for GREEN

Refer attachment.
Hope this is what you are looking for.

Hi. Thanks both for your offer of help. It's much appreciated. I can't however get any of them to work. Do they recognise that it's "working days" i need, rather than a straight run?

Workday in Excel and Conditional Formatting

DebsTurner said:

I can't however get any of them to work.

Click to expand...

Please put your workbook example with results expected.

BTW: Try formula for calculation workday

OK. I've come to realise I've gone about this entirely the wrong way, and I've not explained myself very well at all. Thanks to those who have taken the time to post help thus far. This is what I want the formula to say in cell I2 -

If today is greater than or equal to the date in F2 and is less than or equal to the date in H2, turn green.

If today is equal to H2+1 but less than or equal to I2, turn amber.

If today is greater than I2, turn red.

God I hope that makes sense to somebody.