Forum Discussion
Need help conditional formatting a date column!
Hi, So i've had a look through previous threads & not managed to find the answer. I'm trying to get it so anything @now- 2years turns the cell background red, but anything less than 2 years ago ...
FVaughan there should be a minus - instead of a plus + in that first part of the condition:
=if(@currentField >= @now + 2592000000
as you've got it at the moment it's looking at some date in the future!
Rob
Los Gallardos
Microsoft Power Automate Community Super User