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.

On Jan 5, 3:38*pm, NeoFax <neofa...@gmail.com> wrote:
> 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.

On Jan 6, 8:29*am, NeoFax <neofa...@gmail.com> wrote:
> On Jan 5, 3:38*pm, NeoFax <neofa...@gmail.com> wrote:
>
> > 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.

I guess this is unachievable.