VLOOKUP and colour


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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top