Hi everyone,
I am looking for either a formula or conditional formatting for the below scenario:
- Column A = Staff member
- Column B = Date
I would like the rows to highlight if the value in both of those columns is the same across multiple rows
For example
I would like rows 2 and 4 to highlight because they have the same content in column A and B.
I am looking for either a formula or conditional formatting for the below scenario:
- Column A = Staff member
- Column B = Date
I would like the rows to highlight if the value in both of those columns is the same across multiple rows
For example
I would like rows 2 and 4 to highlight because they have the same content in column A and B.