Kiloelectronvolt
Board Regular
- Joined
- Oct 5, 2015
- Messages
- 81
- Office Version
- 365
- Platform
- Windows
Hi All!
We track incoming construction contracts using excel, but lately there have been a lot of contracts with the wrong address on them.
I would like it so when we enter the owners name, excell will reference our master sheet and turn red if the address does not match.
So, I have a master like this:
Owner 1 : 123 Fake St.
Owner 2 : 456 Fake St
And if my staff enters Owner 1, with 456 Fake St. It will turn red, and let them know something's wrong.
I thought it was Vlookup in conditional formatting, but I can't get it. Maybe I'm going down the wrong path.
Thanks in advance!
We track incoming construction contracts using excel, but lately there have been a lot of contracts with the wrong address on them.
I would like it so when we enter the owners name, excell will reference our master sheet and turn red if the address does not match.
So, I have a master like this:
Owner 1 : 123 Fake St.
Owner 2 : 456 Fake St
And if my staff enters Owner 1, with 456 Fake St. It will turn red, and let them know something's wrong.
I thought it was Vlookup in conditional formatting, but I can't get it. Maybe I'm going down the wrong path.
Thanks in advance!