Hi,
Go to cell E16 then do Conditional formating, where the formula is enter

=$G$16:$J$16<""

if this helps please click yes, thanks

"lightbulb" wrote:

Is there a way to set conditional formatting by referencing another cell?

For Example I'm setting the formatting for cell E16, and I want it to be
green if cells G16-J16 have a value in them.

Thanks!