This company is rebradning all their workbooks, but the colors are all over the place so cannot use the color index to be sure that a field is a particular color. I need to be able to set the color of the font for cell N5 in each workbook a dark blue or grey - anything that is dark and readable, but I can't seem to get the RGB to work.
For Each wks In Worksheets
If Not wks.Name = "Table_of_Contents" And Not wks.Name = "DataSource" Then
wks.Range("N5").Font.Color = RGB(0, 0, 0)
wks.Hyperlinks.Add Anchor:=Selection, Address:="", SubAddress:= _