Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous
On Jan 5, 3:38*pm, NeoFax 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
3-Color Scale Vlookup for Current Month/Previous/Pre-Previous
On Jan 6, 8:29*am, NeoFax wrote:
On Jan 5, 3:38*pm, NeoFax 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date into current and previous quarters | Excel Discussion (Misc queries) | |||
Functions for "current" & "previous" month to calculate data | Excel Worksheet Functions | |||
Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
Previous Month End | Excel Discussion (Misc queries) | |||
automatically update chart plotting current month and previous 6 | Charts and Charting in Excel |