I
icystorm
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
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