Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@vnqt 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.
@vnqt 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.
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
87 | |
59 | |
52 | |
38 | |
21 |