Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to replace the background color of all cells from light green to light blue?
Assume I have a worksheet where some (but not all !!) cells have a background color of light green.
How can I change at once (!) the background color of all those cells to light blue? All other cells should remain unchanged. Claudia |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to replace the background color of all cells from light green
Hi,
Right click your sheet tab, view code and paste this ij and run it Sub swapem() For Each c In ActiveSheet.UsedRange If c.Interior.ColorIndex = 35 Then c.Interior.ColorIndex = 41 End If Next End Sub Mike "Claudia d'Amato" wrote: Assume I have a worksheet where some (but not all !!) cells have a background color of light green. How can I change at once (!) the background color of all those cells to light blue? All other cells should remain unchanged. Claudia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I neen a chart background to represent traffic light colors... | Charts and Charting in Excel | |||
Selected cells show up as very light gray? Can I darken? | Excel Discussion (Misc queries) | |||
Default Row Hi-light Color Intensity | Excel Discussion (Misc queries) | |||
I need to add a blinking red, yellow and green light to an excel | Excel Discussion (Misc queries) | |||
sheet background color suddenly changed to light green from normal | Excel Discussion (Misc queries) |