| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
code to shade row then return it to as it was
This is a repeat post from yesterday which I'm still struggling with. Gary"s
Student offered some help but: Sheet uses columns "A-AD", rows 4-10000. Several sets of adjacent columns are shaded (visually grouped together) to give clarity for the user. Here's the premise: Using a formula in column "AB", either "W", "SD", "ST" or "" will be returned. I need code to look at column "AB" and colour the row (from "A:AD" only) red, orange or blue for the first 3 options or leave as is for "". This part is straightforward ChangeEvent code. However, and this is the bit I can't fathom, if a cell in "AB" is changed from any of the 3 options back to blank, the original cell shading needs to be re-applied. Row 3 is the header row for all the columns, so could the fill colour from that row be used in the code to correctly re-shade the changed row? I can email worksheet if req'd. Thanks Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
code to shade row then return it to as it was
use conditional formatting select columnds D:AD set the 'cell value is' to 'formula is' and then the formula to =$AD1-"W" and then set a pattern color add two more conditions like this for the other two letter patterns conditional formatting allows three tests, so you got lucky! "Jock" wrote: This is a repeat post from yesterday which I'm still struggling with. Gary"s Student offered some help but: Sheet uses columns "A-AD", rows 4-10000. Several sets of adjacent columns are shaded (visually grouped together) to give clarity for the user. Here's the premise: Using a formula in column "AB", either "W", "SD", "ST" or "" will be returned. I need code to look at column "AB" and colour the row (from "A:AD" only) red, orange or blue for the first 3 options or leave as is for "". This part is straightforward ChangeEvent code. However, and this is the bit I can't fathom, if a cell in "AB" is changed from any of the 3 options back to blank, the original cell shading needs to be re-applied. Row 3 is the header row for all the columns, so could the fill colour from that row be used in the code to correctly re-shade the changed row? I can email worksheet if req'd. Thanks Traa Dy Liooar Jock |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
code to shade row then return it to as it was
use conditional formatting
select columnds D:AD set the 'cell value is' to 'formula is' and then the formula to =$AD1-"W" and then set a pattern color add two more conditions like this for the other two letter patterns conditional formatting allows three tests, so you got lucky! "Jock" wrote: This is a repeat post from yesterday which I'm still struggling with. Gary"s Student offered some help but: Sheet uses columns "A-AD", rows 4-10000. Several sets of adjacent columns are shaded (visually grouped together) to give clarity for the user. Here's the premise: Using a formula in column "AB", either "W", "SD", "ST" or "" will be returned. I need code to look at column "AB" and colour the row (from "A:AD" only) red, orange or blue for the first 3 options or leave as is for "". This part is straightforward ChangeEvent code. However, and this is the bit I can't fathom, if a cell in "AB" is changed from any of the 3 options back to blank, the original cell shading needs to be re-applied. Row 3 is the header row for all the columns, so could the fill colour from that row be used in the code to correctly re-shade the changed row? I can email worksheet if req'd. Thanks Traa Dy Liooar Jock |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
code to shade row then return it to as it was
Ideally, yes; if only it were that simple.
I've used CF on quite a few columns already to flag when a date is out of tolerence - hence the request for code. Thanks though, Patrick -- Traa Dy Liooar Jock "Patrick Molloy" wrote: use conditional formatting select columnds D:AD set the 'cell value is' to 'formula is' and then the formula to =$AD1-"W" and then set a pattern color add two more conditions like this for the other two letter patterns conditional formatting allows three tests, so you got lucky! "Jock" wrote: This is a repeat post from yesterday which I'm still struggling with. Gary"s Student offered some help but: Sheet uses columns "A-AD", rows 4-10000. Several sets of adjacent columns are shaded (visually grouped together) to give clarity for the user. Here's the premise: Using a formula in column "AB", either "W", "SD", "ST" or "" will be returned. I need code to look at column "AB" and colour the row (from "A:AD" only) red, orange or blue for the first 3 options or leave as is for "". This part is straightforward ChangeEvent code. However, and this is the bit I can't fathom, if a cell in "AB" is changed from any of the 3 options back to blank, the original cell shading needs to be re-applied. Row 3 is the header row for all the columns, so could the fill colour from that row be used in the code to correctly re-shade the changed row? I can email worksheet if req'd. Thanks Traa Dy Liooar Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| shade one cell that will shade multiple cells | Excel Discussion (Misc queries) | |||
| VBA CODE SOLVER TO RETURN VALUE | Excel Programming | |||
| Return a value for a known code | Excel Worksheet Functions | |||
| Return a value for a known code | Excel Worksheet Functions | |||
| Shade Active Cell - Shade the cell the cursor is in only while in | Excel Programming | |||
Hybrid Mode
