Row from view list interacting with dates (colorization)
I want create a view where it can interacts with a past due date. Here's an example of what I would like it to look like. (file attached)
Basically when today's date is past, I want the row to change color so I know which person has to be recertified.
Let me know if this option is possible and how I could make it work. Thanks
Date Created 11/22/2018 3:04:17 AM
Date Updated 11/22/2018 4:22:36 AM
Scott Miller 11/22/2018 3:23:27 AM
Tick the 'Row Colorization' box at the bottom of the View Setup.
Add this to the Formula box underneath
Yanik Rouleau 11/22/2018 3:27:46 AM
You are the best. The worked like a charm.
Scott Miller 11/22/2018 3:33:32 AM
No problem :-) You might find the View easier on the eye by replacing the "Red" with "#ff6666" or something similar. If you Google HTML Colour codes you'll see the colour charts and the relevant codes.
Yanik Rouleau 11/22/2018 3:39:19 AM
Perfect. Yeah I changed it to that color.
Is there a way to make a time warning color like yellow with it is about to expire. For example 1 month prior the expiration the row would become light yellow?