Hello
I am trying to change the colour of a cell when the date in that cell has passed.
I have tried a conditional formatting rule as uploaded in the word document attached but it doesn't work.
Can you help please?
Hello
I am trying to change the colour of a cell when the date in that cell has passed.
I have tried a conditional formatting rule as uploaded in the word document attached but it doesn't work.
Can you help please?
Last edited by WSRSJT; 08-05-2020 at 10:21 AM. Reason: upload example of formula used
Conditional formatting rule like =A2 < Today() for dates in the past comparing with today's date.
Click the * to say thanks.
Thank you, would you mind looking at the uploaded example of the conditional formatting that I tried - it doesn't work
Please utilize the instructions in the banner at the top of the page to upload an .xlsx file.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you for all your help, the =>TODAY() conditional formatting has worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks