I'm after a method of placing a bottom border (or line) across a
number or columns if a certain cell value is met.

For example, everytime I enter a "2100" in cell A100, I'd like to have
a bottom border span from that cell with "2100" across to column Z.

Can anyone help with a solution, either Conditional Formatting or with
a Macro?

Tks Kaye S