fastballfreddy
Board Regular
- Joined
- Jan 13, 2015
- Messages
- 57
- Office Version
- 2016
- Platform
- Windows
I recorded a macro for adding conditional formatting with part of the code below. I am wanting to know if there is a way to find the color numbers below or is there a substitute code to replace the below code?
when the macro was recording I inputed the hex codes below and the macro created the color numbers. How do I find the color numbers?
Color 12009743 = hex #F1BE48
Color 3018952 = hex #C8102E
when the macro was recording I inputed the hex codes below and the macro created the color numbers. How do I find the color numbers?
Color 12009743 = hex #F1BE48
Color 3018952 = hex #C8102E
VBA Code:
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Font
.Color = -12009743
.TintAndShade = 0
End With
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 3018952
.TintAndShade = 0
End With