ExcelBanter - VLOOKUP and colour

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - VLOOKUP and colour (https://www.excelbanter.com/excel-discussion-misc-queries/155146-vlookup-colour.html)

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

VLOOKUP and colour

Formulas can't do this kind of thing. They bring back values--not formats.

Box666 wrote:

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

--

Dave Peterson