That's great Julie. I'm going to give it a go.

Thanks,

Lawrie



JulieD wrote:
Hi

use can use conditional formatting for this

select the data in columns E through G
choose format / conditional formatting
choose
formula is
type
=INDEX($B$1:$E2,1,MATCH(E2,$B2:$D2,0))="Supplier A"
click on the format button, set the appropriate formatting (BTW you need the
$ only where they are)
OK
click on ADD
formula is
type
=INDEX($B$1:$E2,1,MATCH(E2,$B2:$D2,0))="Supplier B"
click on the format button, set the appropriate formatting
OK
click on ADD
formula is
type
=INDEX($B$1:$E2,1,MATCH(E2,$B2:$D2,0))="Supplier C"
click on the format button, set the appropriate formatting
OK twice

Hope this helps
Cheers
JulieD