I was wondering if this would be possible.

I modified the file and re-uploaded a new file.

I added a "Yes / No" column in column F. If "Yes" is typed into cell F2, cell range A2:F2 gets highlighted with (let's say) a yellow fill.

I'm very curious to see if this is possible.

Your help is greatly appreciated.

Karen