How to use VLookup and Conditional Formatting


I have an excel spreadsheet that has many tabs. On one of the tabs I have laptop asset numbers listed. I have inserted another sheet in the same document and I want to show if a laptop asset number is entered onto the new sheet that matches the information I already have on the other tab that it shows up green to show a match and red if it doesn't match the information that I have on the other tab.

Please help!




You need to use a VLOOKUP function inside a formula like this:


It's just a regular Vlookup inside a ISNA() and NOT() function so it will return TRUE or FALSE as needed.

Then select the cell or cells where you want the color to change and go to the Home tab > click the Conditional Formatting button and go to New Rule > go to Use a formula... > input the above formula and click the Format button to choose the desired green background color.

Format the cells with a red background by default and the conditional formatting will take care of making them green if you follow the steps above.


Answer the Question

You must create an account to use the forum. Create an Account or Login