B
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
=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