Hi, I have a column with dates (UK formatting DD/MM/YY), and would like to set up the cells to change style (eg different colour) once a set number of days has passed from today’s date (I am trying for 2 weeks, or 14 days).
I’ve tried different ways within Conditional Formatting but nothing seems to work. I tried the solutions suggested here without success: Conditional Formatting Based On Date
(No change is made after entering the formulas)
There does not seem to be any other solutions on Google either.
Does anyone have any suggestions to get this working please?