Hi there;
I have 2 different spreadsheet for year 2015 and 2016. Each spreadsheet have staff name in column A and job grade in column B.
How can i highlight the rows in 2016 spreadsheet where new staff or job grade has been increased(promoted) ?
Thanks for help
This solution uses two conditional formatting rules.
The rule to identify new users is: =NOT(COUNTIFS('2015'!$A$2:$A$4,$A2))
The rule to identify users that have been promoted is: =NOT(INDEX('2015'!$B$2:$B$4,MATCH($A2,'2015'!$A$2:$A$4,0))=$B2)
Let me know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks