|
|
#9
01-12-2015, 10:27 AM
|
||||
|
||||
I don't see anything wrong.The references of the CF don't change when you select a cell because the CF applies to the entire range and not only to the cell you selected
Yoy can see for yourself that the formatting is correct by entering your CF formula in a cell and dragging right and down. There you will see the formula adapt,and the TRUE values correspond to coloured cells. It is also so that any formula entered in CF is considered an array formula by XL, and that is how they behave. In conclusion, your solution is perfectly valid 
__________________
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