Microsoft Office Forums - View Single Post - Conditional formatting using specified range instead of With Selection statement

alpha · 01-26-2019, 01:22 AM

Quote:

Next line is an error why?

Code:

Range(Cells(303, 5), Cells(308, 24)).FormatConditions(1).PatternColorIndex = 15
Range(Cells(303, 5), Cells(308, 24)).FormatConditions(1).Pattern = xlGray75

Must be:

Code:

Range(Cells(303, 5), Cells(308, 24)).FormatConditions(1).interior.PatternColorIndex = 15
Range(Cells(303, 5), Cells(308, 24)).FormatConditions(1).interior.Pattern = xlGray75