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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:27 PM.