Forum Discussion
Francesc B.
May 17, 2018Copper Contributor
Time range auto fill colour
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
Hi Francesc B.
Please see the attached file. I just applied it for Range (A2:A24).
Type and test it.
2 Replies
Sort By
- Logaraj SekarSteel Contributor
Hi Francesc B.
Please see the attached file. I just applied it for Range (A2:A24).
Type and test it.
- Francesc B.Copper Contributor
Perfect, that's it!
I was having difficulty finding the formula :)