Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a random group of cells in a range whose background color is blue. I would like to change the background color of all these cells. I know that this can easily be done with a loop that searches for colored cells and makes the change when found. I am wondering, though, if there is any neater way to do this, maybe using a range command or something similar - i.e. for all cells in myRange that are colored blue, change the color to red. Any thoughts if this is possible and how it might be done. -- eugene |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Checkbox to change background color, font color and remove/ add bo | Excel Discussion (Misc queries) | |||
change background color | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) |