I'm stuck here. Can anyone please show me how to use the rgb name in a cell to make the cell adjacent to it change color?
Here's what I've got so far:
Sub SetColour()
Dim Colour As String, rgbColour() As XlRgbColor, n As Long
For n = 1 To Range("A1").CurrentRegion.Cells.Count
Colour...