Conditioning Help

[FatalLordes]

Hi all

Imagine a table like the following:

Name	Desc	Date
Felix	Vax Two	01/10/2023
Gizmo	Vax One	14/03/2024
Felix	Vax One	01/09/2023
George	Vax Three	19/07/2023
George	Vax Three	19/07/2024

What I would like to do is use conditional formatting to highlight a row if one of the following conditions are met:

1. The date for a Vax One is greater than 30 days from today, and there is no Vax Two entry for the same name;
2. The date for a Vax Two is greater than 30 days from today;
3. The most recent date for Vax Three for the same name is greater than 365 days from today

I'm not really sure how to do this. Would it be three separate conditions I need to do? I think I can figure one the second condition but I'm not sure about the first and third. Any help would be greatly appreciated.

Thanks

 

[myall_blues]

Excellent news. I'm glad you got it working and thanks for the feedback.