Home

Formatting a cell (like cell fill color) if current value different than VLOOKUP value

%3CLINGO-SUB%20id%3D%22lingo-sub-468289%22%20slang%3D%22en-US%22%3EFormatting%20a%20cell%20(like%20cell%20fill%20color)%20if%20current%20value%20different%20than%20VLOOKUP%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-468289%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20VLOOKUP%20to%20bring%20in%20values%20for%20selected%20cells%20from%20another%20worksheet%2C%20where%20this%20new%20worksheet%20gets%20updated%20each%20week%20and%20I%20need%20to%20update%20mine%20with%20values%20from%20the%20appropriate%20cells.%26nbsp%3B%20That%20is%20working%20great.%26nbsp%3B%3C%2FP%3E%3CP%3EBut%2C%20I%20also%20want%20to%20be%20able%20to%20format%20the%20cell%20(e.g.%2C%20change%20fill%20to%20yellow)%20if%20the%20VLOOKUP%20value%20brought%20into%20my%20existing%20worksheet%20is%20different%20(i.e.%2C%20if%20it%20represents%20an%20updated%20value%20for%20that%20cell%20from%20what%20I%20had).%26nbsp%3B%20I%20played%20around%20with%20using%20the%20Conditional%20Formatting%20to%20use%20after%20the%20fact%2C%20which%20is%20not%20bad%2C%20but%20you%20have%20to%20be%20careful%20with%20how%20you%20manipulate%20the%20file%20going%20forward%20if%20you%20expect%20it%20to%20work%20well%20as%20you%20go%20through%20updates%20(each%20week%20in%20my%20case).%26nbsp%3B%20And%20the%20cell%20formatting%20is%20dependent%20upon%20having%20the%20Conditional%20Formula%2C%20so%20it%20goes%20away%20if%20the%20Conditional%20Formatting%20formula%20is%20cleared.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20plain%20English%20I%20need%20a%20formula%20that%20essentially%20accomplishes%20this%20for%20each%20cell%20where%20I%20am%20using%20VLOOKUP%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%20o%26nbsp%3B%20Bring%20in%20the%20value%20for%20this%20cell%20from%20the%20corresponding%20cell%20in%20a%20separate%20Worksheet%2C%20and%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20update%20this%20cell's%20value%20with%20the%20one%20from%20that%20other%20Worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%20o%26nbsp%3B%20If%20the%20value%20brought%20in%20is%20different%20than%20the%20one%20that%20was%20there%20before%20the%20VLOOKUP%20was%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20executed%2C%20then%20format%20the%20cell%20(set%20the%20fill%20color%20to%20yellow%20for%20example)%3C%2FP%3E%3CP%3E%26nbsp%3B%20o%26nbsp%3B%20End%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESuggestions%2Fideas%3F%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-468289%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Lucky73
Occasional Visitor

I'm using VLOOKUP to bring in values for selected cells from another worksheet, where this new worksheet gets updated each week and I need to update mine with values from the appropriate cells.  That is working great. 

But, I also want to be able to format the cell (e.g., change fill to yellow) if the VLOOKUP value brought into my existing worksheet is different (i.e., if it represents an updated value for that cell from what I had).  I played around with using the Conditional Formatting to use after the fact, which is not bad, but you have to be careful with how you manipulate the file going forward if you expect it to work well as you go through updates (each week in my case).  And the cell formatting is dependent upon having the Conditional Formula, so it goes away if the Conditional Formatting formula is cleared.

 

In plain English I need a formula that essentially accomplishes this for each cell where I am using VLOOKUP:

  o  Bring in the value for this cell from the corresponding cell in a separate Worksheet, and

      update this cell's value with the one from that other Worksheet.

  o  If the value brought in is different than the one that was there before the VLOOKUP was

      executed, then format the cell (set the fill color to yellow for example)

  o  End formula.

 

Suggestions/ideas?

Thanks!

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies