Forum Discussion

FVaughan's avatar
FVaughan
Copper Contributor
Aug 20, 2020

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 ...
Conditional Formatting based on cell colour
RobElliott's avatar
RobElliott
Silver Contributor
Aug 20, 2020

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

  • FVaughan's avatar
    FVaughan
    Copper Contributor
    Aug 24, 2020

    Hi RobElliott 

    Thanks for that!! Silly me! I;ve altered it, but it doesn't seem to have changed anything.

    I still have some dates in deep red & the rest in light red...

    Any idea on how to make the ones that are 2 years overdue to me deep red, but everything less than 2 yrs green?

     

    Thank you!

Resources