0
I have a field 'Renew By' which I want to change the background colour if the 'Renew By' date is after Today().
How do I achieve this as a formula
Green if before and red if after Today()
Like Follow
1reply
-
Create a formula field with this code:
---
styled(text('Renew By'), if 'Renew By' <= today() then
"green"
else
"red"
end, "")---