Forum Discussion
Modern List View Formatting with UK Dates
Hi everyone I'm trying to use the new view formatting in the Modern UI lists and am coming up against an issue with the date format. I want to colour all rows red where the Due Date column value...
Did you ever manage to resolve this? Facing the same issue and not sure how to proceed.
Dr01dy you can do this with the built-in view formatting to highlight items on or before today:
Rob
Los Gallardos
Microsoft Power Automate Community Super User
This still seems to treat the today as an american date. See screen cap below where dates that fit the next review date is after today criteria do not get their background changed to green.
Dr01dy my screenshot showed the formatting where everything was in UK date format. So I'm not sure why it would be different for you unless something in your regional settings is not set correctly.
Rob
Los Gallardos
Microsoft Power Automate Community Super User