Forum Discussion
Conditional LIne/Border insetion
Task: to watch changes in column numbers
Objective:
- If number increases from previous row then add border of one color (Green)
- If number decreases from previous then add border of another color (Red)
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?
You may apply two conditional formatting rule to your entire range starting from second cell in the range
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.
