|
|
#4
01-09-2015, 10:21 AM
|
||||
|
||||
If you need to turn it off once in a while, a macro would definitely help. I'm sorry I'm not at all proficient with macros.
As for the usual CF you would use something like =a1:a10<$f$20 where f20 contains the comparison value. Note that the range is relative
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
| Tags |
| conditional formatting, loop, macro |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Conditional Formatting | sdfrance | Excel | 3 | 01-06-2015 07:10 AM |
 Conditional formatting that ignores other formatting rules
|
info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
|
Conditional Formatting.
|
Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
|
Conditional formatting with AND, OR
|
Lucky | Excel | 2 | 10-03-2011 11:41 PM |
|
Conditional Formatting
|
namedujour | Excel | 3 | 08-25-2011 01:46 PM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode