Conditional formatting using specified range instead of With Selection statement

alpha · #1 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

slouw · #2 01-26-2019, 03:49 AM

Doh!!!
Thank you much appreciated....

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Individual Rows in a range	Phil H	Excel	3	11-05-2018 12:09 PM
Conditional Formatting - Duplicates - Apply to specified range	music_al	Excel Programming	1	01-25-2017 05:34 AM
Conditional Formatting a Range	Phil H	Excel	3	02-17-2016 08:33 AM
VBA Conditional Formatting Error (Subscript out of Range))	tinfanide	Excel Programming	1	05-15-2015 08:12 AM
Conditional Formatting/If Statement with Dates	AndrewEnos	Excel	2	07-22-2014 07:34 AM