Hello
I really need help.
I have a column with due dates and a column that says completed (Y/N). I would like the the column with Y/N to turn red if the Today() exceeds the due date and in the Completed (Y/N) Column it still says N.
Please help.
Thanks
Hi, and welcome to the forum
Assuming column B is the Y/N column and column A are dates then the conditional format in B1 is
Formula:
Please Login or Register to view this content.
format it red and apply it to the range of cells in column B
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.
Thank you so much for your help. It worked you just made my day
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks