I know how to use conditional formatting for a cell, but is there a way to do
conditional formatting for an entire row?

Example: if cell A18 contains the text, "total" then row 18 has a top and
bottom border.

Thanks, Heather