Hi BVG
Use this formula in the Conditional Formatting property of Cell H2:
=AND(H2="No",G2<NOW()+1)
Good luck.
Tony