Does anyone know how to conditionally format an entire row based on value of
1 cell in that row. For example, I have a list of clients at our agency, but
when they are terminated I would like to be able to highlight the line in
gray instead of just deleting the record.