Hi folks,
I'm trying to create a spread sheet to compare company codes with pay groups and if they match. It would look like this
Company....Pay group....Company - Pay Group Correspondence
6343..........Monthly.......Y
4534..........Daily...........Y
4453..........Monthly.......Y
9942..........Daily...........N
What I'm trying to do is to create relations between two values (6343=Monthly) and if they don't match in the thrid column shoud be shown "N", if they match "Y". And as a extra I would like if the Company and the Pay group are shown with a yellow background if they do not match. I tried everything but I'm not able to create this formula. I have to say that my Excel knowledge is very very basic.
Can somebody please help me?? Thank you so much.
Greetings,
Alex
Bookmarks