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

  • Thread starter Thread starter NeoFax
  • Start date Start date
N

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.
 
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.
Click to expand...

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.
 
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.
Click to expand...

I guess this is unachievable.
 
Back
Top