Hi, try this:


Select G5 to I5,>>conditional formatting>>manage rules>>use a formula to... then enter the ff formula in the box
=$F5<>TODAY()
Format>>Fill>>Grey