Format at change in Value

[jharvey87]

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?

 

[JoeMo]

Did you select the entire range from A4 to BJ?? before entering the CF formula?

If yes, the formula should be:

=$A4<>$A5

 

[Jonmo1]

If you want the whole row (From A to BJ) to highlight, then you need to lock the column references in the formula

=$A4<>$A5

 

[jharvey87]

If you want the whole row (From A to BJ) to highlight, then you need to lock the column references in the formula

=$A4<>$A5

That was it. Thanks for the help!