VLOOKUP and colour

[Box666]

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]

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