Hi,

I have a column on my sheet - column 'K' as 'Delivered date'. I want the entire row relating to this to turn green when any date is entered into column 'K'.

This is a live ongoing sheet so the rule would only be applicable to when data is inputted into 'column K'. As its a sheet that gets updated throughout the year at different times and days, I can't set it to specific dates.

Wondered if anyone knows the formula for this?

Thanks