Forum Discussion
Formating the date column
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
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.
1 Reply
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.