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?
3 Replies
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.
