Dear Sir,

I have the following table at my workshhet :


A B
1 254 CN
2 321 CN
3 340 CN
4 147 DN
5 321 DN
6 110 DN
7 98 IV
8 654 IV
9 447 RT
10 988 RT
11 228 DJ
12 356 DJ

May I know is there a way to conditional shading the numbers in column A by
using reference codes in column B ?

Alternatively shading both column A and column B by using the same reference
code. i.e. figues for CN - light yellow, RT-light red DJ - light blue and so
on

Also can this be done at a single dialog box for all the different codes (
10-12) ?

Thanks

Low


--
A36B58K641