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.