Highlight Today's Date IF

[Alex501]

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

 

[Fluff]

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.

 

[Toadstool]

Hi Alex501,

Does this work?

Alex501.xlsx
	A	B
1	Next Contact Date	Complete
2	10/3/2021	No
3	10/4/2021	Yes
4	10/5/2021	No
5	10/6/2021
6	10/5/2021
7	10/4/2021	Yes
8	10/5/2021	Yes
9	10/5/2021	No
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A9	Expression	=AND(A2=TODAY(),B2="No")	text	NO

Cells with Data Validation
Cell	Allow	Criteria
B2:B9	List	Yes,No

 

[Alex501]

Hi Toadstool

Works perfectly.

Thanks

Alex

 

[Toadstool]

Hi Toadstool
Works perfectly.
Thanks
Alex

You're welcome.