Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
question regarding dynamic cell colors
Excel version: Excel 2003 Pro SP2
Overview: I have created an Excel work schedule that displays days of the week along a single row near the top. (e.g. S M T W T F S [...] etc.) All additional rows in the array consist of various formulas. The entire array is 29 rows by 450 columns. Issue: In the row that displays days of the week, I want to find *all* cells that contain "S" (for Saturday and Sunday). Then, I want to change the cell color for those days to gray, and I also want the entire range in the column beneath each "S" to be shaded gray as well. I realize that conditional formatting is not a solution in this case. I am hoping that someone with VBA experience has already addressed this issue and developed a viable solution. The final product should show all weekend columns displayed as gray. Obviously, I do not want the gray cell coloring to extend beyond the bottom or top of the array, either. Thanks kindly for sharing your ideas and ingenuity. Best Regards, J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating - dynamic data bar colors | Excel Discussion (Misc queries) | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Excel Programming | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
Conditional Formatting Question - Different Cell Colors?? | Excel Discussion (Misc queries) |