I think you want the line only when Status in the current row is 'Multiple'
and the status in next row is blank...

Assuming you have headers and your data starts at row 2... select the range
you want to underline starting at second row and use the
FORMULA IS in Conditional Formatting as
=AND($D2="Multiple",$D3="")
and choose the Underline format

"KKD" wrote:

I want to create an underline border for a row containing a particular value.

Example:
(Headers) PO# Inv# Amt Status
(Data) ABC 123 $50.12 Multiple
ABC 456 $47.00 Multiple
AXX 789 $21.00

In this example, I want an underline to appear under the last data row that
contains a repeated PO#. So an underline would appear under the middle row,
because that is the last row of the "ABC" PO#. However, I do NOT want
underlines to appear under rows that only have a single PO#.

The status column is set up to read "multiple" if there are multiple rows
using that PO# and the status is blank if it is a single occurrence. The rows
are usually sorted by PO#.




--
KKD