shade every other line with condition
 

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!

shade every other line with condition
 

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!