Conditional formatting - Thick bottom border
Solved
invitéedujour
-
invitéedujour -
invitéedujour -
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 réponses
Hello
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:
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!
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!
Best regards.