Change VLOOKUP value based on color scheme??

[thewiseguy]

My VLOOKUP looks like this:

=VLOOKUP(A3,INVENTORY,5,FALSE)


I would like to tweak the formula so that if the color scheme in A3 is red (Red:255, Blue:0, Green:0), then the VLOOKUP will return the negative value of what it normally would. So if the value returned using the original VLOOKUP is 20, the negative value would be -20 (if the color scheme is red).

Is this possible?

 

[arthurbr]

Hi,
there's an UDF here :http://www.cpearson.com/excel/colors.htm that might get you started. It returns the colorindex of a cell
HTH