Hello. Newbie in the room. But generally know my way around Excel. I've got a spreadsheet with a large number of rows (circa 10,000) and circa 38 columns. My data doesn't start until row 9 with headings and spreadsheet titles above. I've setup a Conditional Formatting formula rule but it doesn't survive a filter. There are a number of suggestions I've found in various places but nothing seems to work.

Does anyone have any suggestions on how I could get this to work?

Cheers
Hadders