Formating the date column

[Anonymous]

Hello,

I would like to color the date column  as below : 

IF date < 2 months : RED

2 - 4 months : Orange

> 4 months : green

Name	Value	Date
Name 1	Value 1	09/10/2023
Name 2	Value 2	20/09/2023
Name 3	Value 3	20/09/2023
Name 4	Value 4	20/09/2023
Name 5	Value 5	10/03/2023
Name 6	Value 6	11/03/2023
Name 7	Value 7	12/03/2023

Result : 

Could you please advise ? 

Thank you in advance.

Tg

[devesh_gupta · Accepted solution]

@Anonymous You can use rule based conditional formatting to color the date column. You can refer this video to know how to implement rule based conditional formatting.

https://youtu.be/Fq0JneLDbGs?si=hTyyxWF-407Acrbp

If you find this insightful, please provide a Kudo and accept this as a solution.