Forum Discussion
Conditional LIne/Border insetion
Using a border as the changing element, rather than the background, I have done exactly what you show, and entire area effected only responds to evaluation of Cell $A$1. The experience on my end suggests that I would have to apply the conditional formatting manually to each and every cell in the section that I want to look at. to achieve what I want.
Trying to be polite. It would be faster for me just to do this manually (cell by cell) than attempting staging a conditional format that adds a border. Sorta back to square one.
Of course that's your choice. As a comment
- you shall use relative references in the formula, not absolute one
- you may apply any format you wish - borders, background, fonts, whatever. It doesn'r depend on the rule formula
- if you have few separate ranges, after applying CF to one of them, you may copy formatting on another one by Format Painter.