Hello there,

Please help. I have coloured the cells in Rows A1:E1 blue.

Using a macro, I would like Excel to check each value in the above row and
colour the corresponding digit value blue in the range A5:E5.

(I have used up all 3 Conditional Format options, hence the need to use
macros for further cell formatting).

Thanx

--
KCG