| 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. |
| 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 | |||
Threaded Mode
