I have a spreadsheet which is approx 1000 rows long but varies month to
month. I'm trying to figure out a way to shade the entire row in grey if a
cell in column e equals the value "total". This is the only consistent
differentiating cell which would indicate whether i want the row highlighted
or not. Conditional formatting only allows you to define formatting at the
cell level. Any help would be appreciated as I certainly do not want to
manually format the spreadsheet monthly.

Thanks