I need to cross check data. I would like to do it visually.
I have a list of employees and a row of months
I have a "1" in any month where the employee received earnings.
I would like to cross check it with an hourly report.
I have a list of employee numbers, followed by months, and hours worked.
If they worked in a given month, I would like to highlight that cell..lets say green.
So if a cell is green and has a "1" in it, it checks.
Any cell that is green without a "1" needs to be examined further.
I'll attach an example
Thanks guys/gals
Example 2.xlsx
Bookmarks