Highlight Cell, But Only If Cell Beneath Is A Duplicate

[indi visual]

I am looking for help with highlighting cells in a column, but only if the cell directly beneath it contains the same text.


I.E. If the cell beneath it doesn't contain the same text nothing is highlighted.

 

[indi visual]

I thought I could use conditional formatting, but I'm not sure I can simply use the CF tool in Excel with what I'm doing.


I need to highlight (or make bold or italic or anything) the album names in a column, if that same name is directly underneath it that is.

 

[Hui]

@Indi

If your Data is A1:A100

Select your data

Use a CF: =A1=A2 and set the format

 

[indi visual]

Boom.


Right on the money Hui.


Resolved thanks.