Hi everyone,

I'm using index match to pick up data from another sheet in the same workbook.


=INDEX(_2007Low,MATCH($B$1,Room,0))
=INDEX(_2007Res,MATCH($B$1,Room,0))
=INDEX(_2007Upp,MATCH($B$1,Room,0))

Data
A B C D E
4 315 Blank 80 83 88
5 316 Blank 64 Blank 75
6 317 Blank 65 70 76

C is _2007Low
D is _2007Res
E is _2007Upp

The way the data sheet has been set up is that the Result in D is formatted
with shading but when it falls on the upper or lower limit D is left blank
and the value in either C or D is shaded.

So I'm pulling data from C,D and E but would like to know if It's possible
to pull any shading along with it?

Many thanks
Diddy