Highlight Today's Date IF

Alex501

Board Regular
Joined
Dec 11, 2015
Messages
53
Office Version
  1. 365
  2. 2019
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 taht makes sense.

Thanks

Alex
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Highlight Today's Date IF
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0
Hi Alex501,

Does this work?

Alex501.xlsx
AB
1Next Contact DateComplete
210/3/2021No
310/4/2021Yes
410/5/2021No
510/6/2021
610/5/2021
710/4/2021Yes
810/5/2021Yes
910/5/2021No
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:A9Expression=AND(A2=TODAY(),B2="No")textNO
Cells with Data Validation
CellAllowCriteria
B2:B9ListYes,No
 
Upvote 0
Solution

Forum statistics

Threads
1,213,565
Messages
6,114,337
Members
448,568
Latest member
Honeymonster123

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top