I'm having an issue doing this with conditional formatting. Column A has a list of names. When those names change, i want it to underline the row from A to BJ. I highlighted the entire range and did =A4<>A5 (conditional formatting). This did not work though.
Any help would be greatly appreciated.
Does this need to be a macro?
Any help would be greatly appreciated.
Does this need to be a macro?