Conditional Formatting if adjacent cell is >60 Days Ago and Targeted Cell is Blank

[braytoar]

For context, creating a tracker highlights client touchpoints. In row H, I have it successfully setup that most recent meeting dates <30 days old are green, those between 30-60 days old are yellow, 60-90 days are orange, and >90 days old are Red.

The adjacent column G is for the currently scheduled FUTURE meetings. And what I want is for those Column G cells to turn RED if the cell is BLANK but only if the most recent meeting (adjacent Column H cell from above conditional rules) is >60 days ago.

Any help??

 

[6StringJazzer]

Let's try this:

$scratch.xlsm
	G	H
1	Future	Past
2	1/1/2024	12/1/2023
3	1/1/2024	7/1/2023
4		12/1/2023
5		7/1/2023
Sheet1 Copy

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G:G	Expression	=AND(G1="",H1>0,TODAY()-H1>60)	text	NO