View Single Post
 
Old 07-14-2014, 01:02 PM
EC37 EC37 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
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