nagovind
Member
Dear All,
Kindly advise the code to find the cells that are with the specified colour and then replace the Colour shade of a cell with the selected colour
Example
The Below code does the job of manually selecting the cells. How to automate the same with a code for a sheet without selecting any cells

Kindly advise the code to find the cells that are with the specified colour and then replace the Colour shade of a cell with the selected colour
Example
The Below code does the job of manually selecting the cells. How to automate the same with a code for a sheet without selecting any cells
Code:
Sub C1()
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 11433822
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
Sub C2()
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
.Color = 19444052
.TintAndShade = 0
.PatternTintAndShade = 0
End With
End Sub
