Conditional formating date over a week old
Hi guys,
So now, I want to grey out a date cell when the date is a week old. Like a conditional formatting feature, but not within seven days but after seven days.
I was thinking of something like =AND(B2<>"",B2>TODAY-7 but this doesn't work and I kinda just made it up so I doubt it even exists.
Anyone?
Hi,
You've missed the ()
Use
Formula:
Please Login or Register to view this content.
remove the spaces around the chevrons.
The forum objects to these and the firewall throws up an error so I'm curious as to why it accepted your string.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks