Help! I spent all afternoon cross referencing this spreadsheet with another one to make sure some software was correct. However, i got a bit trigger happy when I was comparing the documents, one being in CSV format and closed it thinking I had saved it. However, I had NOT!
I spent all afternoon on this but now I have lost it
So if any of you wizkids could help me that would be great. I'm looking for something in the lines off:
The document on the left is more up to date. The one on this right needs updating. I think I would need to use conditional formatting, so that those with matching Workstation and Telephones would highlight green, and those that do not are red. (they're in two seperate spreads for now, but they will be two seperate tabs in the workgroup)
I spent all afternoon on this but now I have lost it
So if any of you wizkids could help me that would be great. I'm looking for something in the lines off:
The document on the left is more up to date. The one on this right needs updating. I think I would need to use conditional formatting, so that those with matching Workstation and Telephones would highlight green, and those that do not are red. (they're in two seperate spreads for now, but they will be two seperate tabs in the workgroup)