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