Time range auto fill colour

[Francesc B.]

Hello,

I would like to introduce a formula that will fill in red the cell with a time range between today and the next 15 days, yellow between the following 15 days, and green a cell with a date later that 30 days from now.

How can I do it?

Thank you very much

[#2 · Accepted solution]

Hi @Francesc B.

Please see the attached file. I just applied it for Range (A2:A24).

Type and test it.

[#3]

Perfect, that's it!

I was having difficulty finding the formula :)