Conditional formatting - Thick bottom border
Solved
Hello,
how to make a thick border at the bottom of the line when the value changes?
Example:
100012
100012
100012
800123
800123
655423
Desired border on the last line of 100012 and on the last line of 800123, etc.
how to make a thick border at the bottom of the line when the value changes?
Example:
100012
100012
100012
800123
800123
655423
Desired border on the last line of 100012 and on the last line of 800123, etc.
2 answers
-
ContributorHello
MFCs do not allow adding thick borders, only the standard thin border
however, you can:
place a thick border under all the cells
make it disappear as long as the value does not change
example from A1 to A100 to adapt:- select A1:A100
- apply your border to all cells
- conditional formatting by formula
- enter the formula: =A1=A2
- format: remove the bottom border in the borders formatting options
the border will only remain visible when the value changes
best regards
--
The quality of the response mainly depends on the clarity of the question, thank you! -
Contributor
Hello.
This option does not exist,
nor does the double line.
But you could choose
a colored border.
Retirement is nice!
Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
