Change Row Color Based on Cell Value in Col A and B
 

I have a lot of data and it's hard to find stuff among different categories.
I frequently sort and filter rows of data, so I need a dynamic solution.

I"m envisioning adding two buttons. One to enact the formatting below, and
another to remove the formatting below. Thanks for your help!

Starting at Row 13 and through Row 3000

Col A Col B Cols C through AS
Apples Little Entire row should be light green
Apples Little Entire row should be light green
Apples Big Entire row is blue, but insert line between big
and little row
Apples Big Entire row should be light green
Apples Big Entire row should be light green
Oranges Bad Entire row is now white, insert line for row between
apls orngs
Oranges Bad White Row
Oranges Good White Row, insert line
Pears Fine Entire row is now light green, insert line
etc..


Thanks... I may be getting ahead of myself because I have another thread on
a seperate subject to close, but I intend to work on these over the weekend...

Change Row Color Based on Cell Value in Col A and B
 

Have you tried conditional formatting? Won't work for inserting rows, but
you could add a border above or below and it will take care of colors easily.
You can set up multiple criteria for a given range. Highlight range of
cells you want to format, then use formula = $A1="Apples" and pick light
green fill color. Add additional criteria for oranges, pears, size. For
adding rows, I think you'd need a macro but this simpler approach might work.

"SteveC" wrote:

I have a lot of data and it's hard to find stuff among different categories.
I frequently sort and filter rows of data, so I need a dynamic solution.

I"m envisioning adding two buttons. One to enact the formatting below, and
another to remove the formatting below. Thanks for your help!

Starting at Row 13 and through Row 3000

Col A Col B Cols C through AS
Apples Little Entire row should be light green
Apples Little Entire row should be light green
Apples Big Entire row is blue, but insert line between big
and little row
Apples Big Entire row should be light green
Apples Big Entire row should be light green
Oranges Bad Entire row is now white, insert line for row between
apls orngs
Oranges Bad White Row
Oranges Good White Row, insert line
Pears Fine Entire row is now light green, insert line
etc..


Thanks... I may be getting ahead of myself because I have another thread on
a seperate subject to close, but I intend to work on these over the weekend...

Change Row Color Based on Cell Value in Col A and B
 

I'll give that a shot and post the results if I need any tweaking... thanks
for the suggestion

"Cornelia" wrote:

Have you tried conditional formatting? Won't work for inserting rows, but
you could add a border above or below and it will take care of colors easily.
You can set up multiple criteria for a given range. Highlight range of
cells you want to format, then use formula = $A1="Apples" and pick light
green fill color. Add additional criteria for oranges, pears, size. For
adding rows, I think you'd need a macro but this simpler approach might work.

"SteveC" wrote:

I have a lot of data and it's hard to find stuff among different categories.
I frequently sort and filter rows of data, so I need a dynamic solution.

I"m envisioning adding two buttons. One to enact the formatting below, and
another to remove the formatting below. Thanks for your help!

Starting at Row 13 and through Row 3000

Col A Col B Cols C through AS
Apples Little Entire row should be light green
Apples Little Entire row should be light green
Apples Big Entire row is blue, but insert line between big
and little row
Apples Big Entire row should be light green
Apples Big Entire row should be light green
Oranges Bad Entire row is now white, insert line for row between
apls orngs
Oranges Bad White Row
Oranges Good White Row, insert line
Pears Fine Entire row is now light green, insert line
etc..


Thanks... I may be getting ahead of myself because I have another thread on
a seperate subject to close, but I intend to work on these over the weekend...