| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to highlight cells depending on value from vlook up?
Hi all, Need some help! Want to highlight cells depending on a value returned by a vlook up formula. If a value of 6 (could be anything from 2 to 50) is returned in cell A100 (could be any column, cell) then highlight the next 6 cells down (also in some cases the cells above instead of below). Can this be done with out the use of a macro? A column will only need to be highlighted up or down. So looking for 2 formulas one to highlight down and one to highlight up, which I can paste in every other column. New to excel don’t know if this is straight forward or not. Hope I’ve explained myself clearly, any assistance would be appreciated. Cheers -- JAZZNAURA ------------------------------------------------------------------------ JAZZNAURA's Profile: http://www.excelforum.com/member.php...o&userid=36961 View this thread: http://www.excelforum.com/showthread...hreadid=572793 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get back the sum feature when I highlight cells? | Excel Worksheet Functions | |||
| cells wont highlight | Excel Discussion (Misc queries) | |||
| Reference range of cells and perform subtraction or nothing depending on contents | Excel Worksheet Functions | |||
| highlight cells equals sum, not count | Excel Discussion (Misc queries) | |||
| How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
Threaded Mode
