3-Color Scale Vlookup for Current Month/Previous/Pre-Previous

[NeoFax]

Is it possible to Conditionally Format a cell so that the colors are
based off of VLOOKUP's? What I mean is I have a table on another tab
and it has by month how complete the build is. I want the conditional
format to color the percent of the current month red, percent of
previous month yellow and pre-previous month green. I tried putting
the formula =("41227-1",BuildData,18,FALSE) as the current, =
("41227-1",BuildData,17,FALSE) as the previous, and =
("41227-1",BuildData,16,FALSE) as the pre-previous. However, it uses
only the cells value to color and it always colors the scale red.

 

[NeoFax]

Is it possible to Conditionally Format a cell so that the colors are
based off of VLOOKUP's?  What I mean is I have a table on another tab
and it has by month how complete the build is.  I want the conditional
format to color the percent of the current month red, percent of
previous month yellow and pre-previous month green.  I tried putting
the formula =("41227-1",BuildData,18,FALSE) as the current, =
("41227-1",BuildData,17,FALSE) as the previous, and =
("41227-1",BuildData,16,FALSE) as the pre-previous.  However, it uses
only the cells value to color and it always colors the scale red.

So my second thought was to try and get the three values into the
cell, but that didn't work. So my question now is can Conditional
Formatting gradient color a single cell based off of three different
values? i.e. Value A is 50%, Value B is 75%, Value C is 90% and from
0-50 the color is blue and 51-75 purple and 76-90 the color is yellow.

 

[NeoFax]

So my second thought was to try and get the three values into the
cell, but that didn't work.  So my question now is can Conditional
Formatting gradient color a single cell based off of three different
values?  i.e. Value A is 50%, Value B is 75%, Value C is 90% and from
0-50 the color is blue and 51-75 purple and 76-90 the color is yellow.

I guess this is unachievable.