Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find purple cell color, change to red
Select range and the run this macro.
Sub ChangeColor() Dim rng As Range, c As Range ' Set rng = Selection For Each c In rng If c.Interior.ColorIndex = 13 Then ' Change if not correct value for ColorIndex c.Interior.ColorIndex = 3 End If Next c End Sub HTH "goofy11" wrote: I'm new to VBA and am interesting in having macro that after highlighting a range of cells, would evaluate each cell's color. For every cell that is purple, I want it to be changed to red. Thanks, Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the color the cell becomes when doing a FIND | Excel Discussion (Misc queries) | |||
How do I change the color coding with Find & Replace? | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
How do I find highest number in a row and change color? | Excel Worksheet Functions | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |