Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |