| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP and colour
I have a front sheet that uses Vlookup to populate it, for example
=IF(ISERROR(VLOOKUP($E11;Vlookup!$A$5:$ER$59999;4+ ($B$17-1)*9+I $7;FALSE));"";VLOOKUP($E11;Vlookup!$A$5:$ER$59999; 4+($B$17-1)*9+I $7;FALSE)) I now need to colour code the original cells via "Fill Colour", at the moment that fillcolour is not brought forward to the main front sheet. Is there a way I can bring colour coding forward with the Vlookup, either by fill colour or font colour. Any thought greatfully received. Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
| can the fill colour of a bar be tied to the data font colour data | Charts and Charting in Excel | |||
| bar colour | Charts and Charting in Excel | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Text in Blue colour, but print in black colour | Excel Worksheet Functions | |||
Threaded Mode
