How to replace the background color of all cells from light green
Right click your sheet tab, view code and paste this ij and run it
For Each c In ActiveSheet.UsedRange
If c.Interior.ColorIndex = 35 Then
c.Interior.ColorIndex = 41
"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.