Forum Discussion
Odin Perez
Jul 01, 2018Copper Contributor
Conditional formatting not working properly as one of the comparing cells contains a vlookup formula
Hi, I'm having problems with a simple conditional formatting as one of the comparing values is a vlookup formula and not a number. I did the comparison with another set of data containing ju...
Wyn Hopkins
Jul 01, 2018MVP
Hi Odin,
You could try =VALUE($B2) <> VALUE($G2)
You could try =VALUE($B2) <> VALUE($G2)