Forum Discussion
multiple cell color formatting
I'm wondering how to reformat the cell fill color across an entire sheet, i.e., I want to change all of the orange filled cells to blue. I have excel for Mac 2018 v16.16.5 and don't see a find an...
No sorry, there's no option for this in the Mac version.
Here the answer if anyone can use it.
Run it in macros
Sub ColorCoding()
For Each sheet in Worksheets
For Each rCell In sheet.Range("A3:CC500")
If rCell.Interior.ColorIndex = 45 Then
rCell.Interior.Color = RGB(255, 204, 153)
ElseIf rCell.Interior.ColorIndex = 33 Then
rCell.Interior.Color = RGB(153, 204, 204)
ElseIf rCell.Interior.ColorIndex = 35 Then
rCell.Interior.Color = RGB(204, 204, 153)
End If
Next rCell
Next sheet
End Sub
