Sep 20 2019 01:08 PM
Task: to watch changes in column numbers
Objective:
Format: Through out one section of a spreadsheet.
Comments: I've looked at conditional formatting and it only 'seems' to work on cell by cell conditioning. Where I need several hundred cells considered (top to bottom) and marked. Can this be done. and how is this done if it is possible?
Sep 20 2019 02:55 PM
You may apply two conditional formatting rule to your entire range starting from second cell in the range
Sep 22 2019 10:08 AM
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.
Sep 23 2019 04:20 PM
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.