Conditional formatting using specified range instead of With Selection statement

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Conditional formatting using specified range instead of With Selection statement

FAQ

Thread Tools

Display Modes

01-26-2019, 01:22 AM

alpha

Windows 10 Conditional formatting using specified range instead of With Selection statement

Office 2010 64bit

Novice

Join Date: Jun 2018

Posts: 18

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:41 AM.