![]() |
|
#3
|
|||
|
|||
|
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 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. |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 Excel 2007
|
namedujour | Excel | 6 | 08-04-2011 10:52 AM |