See response in worksheet functions news group.

Not much point in multi-posting.

Most of the regulars monotor all the Excel groups.

Multi-posting just serves to fragment responses and waste time and effort.


Gord Dibben MS Excel MVP


On 3 May 2007 15:32:45 -0700, wrote:

I need to shade every other line in a spreadsheet. The only ways I
have been able to figure out how to do this is by setting conditional
formatting to shade even and odd rows. Unfortunately, the data changes
from week to week, and I need to subtotal and shade based on
conditions (OH and Sold) rather than even/odd rows. Here is what the
spreadsheet looks like:

Style ID Mat ID Color ID Size Total
8C0303 UP8 F0AEB 80 OH 0
8C0303 UP8 F0AEB 80 Sold 0
8C0303 UP8 F0AEB 80 OH 3
8C0303 UP8 F0AEB 80 Sold 0
8C0303 UP8 F0AEB 85 OH 0
8C0303 UP8 F0AEB 85 Sold 0
8C0303 UP8 F0AEB 85 OH 5
8C0303 UP8 F0AEB 85 Sold 2
8C0303 UP8 F0AEB 90 OH 0
8C0303 UP8 F0AEB 90 Sold 0
8C0303 UP8 F0AEB 95 OH 0
8C0303 UP8 F0AEB 95 Sold 0
8C0303 UP8 F0AEB OH 8
8C0303 UP8 F0AEB Sold 2


8C0303 UP8 F0GU3 70 OH 0
8C0303 UP8 F0GU3 70 Sold 0
8C0303 UP8 F0GU3 70 OH 3
8C0303 UP8 F0GU3 70 Sold 1
8C0303 UP8 F0GU3 75 OH 0
8C0303 UP8 F0GU3 75 Sold 0
8C0303 UP8 F0GU3 75 OH 4
8C0303 UP8 F0GU3 75 Sold 1
8C0303 UP8 F0GU3 80 OH 0
8C0303 UP8 F0GU3 80 Sold 0
8C0303 UP8 F0GU3 80 OH 0
8C0303 UP8 F0GU3 80 Sold 1
8C0303 UP8 F0GU3 85 OH 0
8C0303 UP8 F0GU3 85 Sold 0
8C0303 UP8 F0GU3 85 OH 0
8C0303 UP8 F0GU3 85 Sold 1
8C0303 UP8 F0GU3 90 OH 0
8C0303 UP8 F0GU3 90 Sold 0
8C0303 UP8 F0GU3 OH 7
8C0303 UP8 F0GU3 Sold 4


What would the correct formula be to plug into the Conditional
Formatting in order to shade every row that contains OH?

Thanks so much for your help!