Hi
Is there a way to highlight today's date in a column dependant on a lookup list item?
I have a columnn with a list of dates called 'Next Contact Date' and the next column is called 'Complete' with a yes/no lookup list, what i'm trying to achieve is that today's date is highlighted if the lookup list item is No but unhighlight if the lookup list item is Yes.
Hope that makes sense.
Thanks
Alex
Welcome to the forum.
You'll need a simple conditional formatting rule.
Assuming today's date is in A1 and the YES/NO lookup is in D1, then the rule for A1 is this:
=D1="YES"
If you've over-simplified your description of what you want, then there are instructions at the top of the page explaining how to attach your sample workbook.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Administrative Note:
Oh, dear - it looks like you haven't read our rules yet ...
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
(Note: this requirement is not optional. As you are new, I will do it for you today: https://www.mrexcel.com/board/thread...te-if.1183738/.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks