Excel 2007 : Identify unique employees, and employees with a change in hours

Hey there,

Think I have what you're looking for. Unique employees have blue conditional formatting and I've used:

=AND(A3=A4,B3<>B4)

As a conditional format to highlight entries that have the same name but different hours. The only thing required is that the names match exactly each month and you need to sort them by name for it to show correctly.

Hope that helps.

Thank you very much that is exactly what I was looking for.