Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-14-2014, 01:02 PM
EC37 EC37 is offline Conditional Formatting problem Windows 7 64bit Conditional Formatting problem Office 2010 64bit
Advanced Beginner
Conditional Formatting problem
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default

Sorry for the late response- but thanks. I had been googling what formula to use initially- before I saw your response. But makes sense to take the "IF" out of the equasion.

Anywho- I realized some mistakes with my code as well and fixed. Everything works properly now. One of the main problems was I had copied the format and didn't change some things. For instance:

Code:
org.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
If you look at my original post, I never Selected anything, therefore using "Selection" makes no sense. So Selection was replaced with what I should have been referencing: '(org.FormatConditions.Count)'.

There were a couple of other minor tweaks made before it started to work properly. But appreciate the response!
I only come on here during work, and had some crap I had to attend to Thurs, and don't work on Friday's.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting problem Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional Formatting jdc15371 Excel 2 06-26-2014 06:34 AM
Conditional Formatting problem Problem with Conditional Formatting wrighty50 Excel 11 03-25-2012 10:42 AM
Conditional formatting zanat0s Excel 4 01-20-2012 03:30 AM
Conditional Formatting problem Conditional Formatting Problem Excel 2007 namedujour Excel 6 08-04-2011 10:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft