I have Columns B:H with row 2 being headings. If a tag column three columns after the last column has the word 'Attend', I would like that cell to be shaded. The last column will change as new columns are added. Can someone correct the criteria in the conditional formatting below?

Please Login or Register  to view this content.
Thank you for your help.