VLOOKUP - CHANGING FONT COLOR WHEN CRITERA CHANGES

[Tillie Rose]

I am using a vlookup function to verify information that has already been
entered. If the information is wrong and the vlookup function changes the
number I would like the text to change color so I can see which cells
changed. any ideas how I can also tell it to do that?

 

[papou]

Hello
See conditionnal formatting from the Format menu.
HTH
Cordially
Pascal

 

[Tillie Rose]

gI tried conditional formatting but it changes all the text not just the
ones that it made changes to with the vlookup formula. How do I just get it
to recognize only the ones that changed?

 

[Tillie Rose]

I tried conditional formatting but it changes all the text not just the
ones that it made changes to with the vlookup formula. How do I just get it
to recognize only the ones that changed? It is the vlookup function that is
causing me problems