Can You Use Conditional Formatting icw VLOOKUP !?!

[IM_STUCK]

Is it possible to use Conditional Formatting in conjunction with VLOOKUP?

Spreadsheet has VLOOKUP and is working great.

Spreadsheet is to be provided as a Form so users can request changes to various fields.

Intent is so that after the form is populated (from VLOOKUP) - if a later change is made to any cell (that is used by VLOOKUP) - that the background color of that particular cell changes.

Are there any other options?

Thank you,

 

[jdm21788]

I'm not entirely sure what you are asking- how would this be different from any other application of conditional formatting? You should simply be able to highlight the target cells (the ones that update using vlookup), go to format - conditional formatting, and add conditions. Conditional format only references the value of the cell, not the formulas behind it.

 

[IM_STUCK]

I was under the impression that if they change the content of the cell (which is the equation pointing to another cell) that the equation would no longer be valid

Example: Cell A points to Cell Q w/ VLOOKUP
Cell Q (and now A) contents say "HUNT"

User Changes Cell A contents to say "FISH"
which would delete the VLOOKUP equation

If that is the case - how can the conditional formatting see the cell that the equation points to, if the equation is no longer there?

Very new to this, am I missing something ?

Thank you...

 

[jdm21788]

So you want the changed cell to be highlighted if it is not one of the vlookup values? Or do you want it to be highlighted if it changes at all?

 

[IM_STUCK]

If it changes from what is in the referenced cell.