Column G has either yes or no answers. I only want to highlight yes that are in the g column based off k76 date. Either today or in future...

I either get all or i end up getting only those prior to date in k76.

Any ideas?
Thanks Jack