VB Macro for cell colour default

Giganews Newsgroups
Subject: VB Macro for cell colour default
Posted by:  KCG
Date: Tue, 28 Aug 2007

Hello there,

I have used up all conditional formatting. Please help me with developing a
Macro for further cell formatting as follows:

I have this range of numbers in the row A10:G10

12 5 26 3 17 38 9 23

If any number in this list is in the range A1:G9, I need the macro to colour
that found value's cell, blue.

Thanx for your help.

Regards

--
KCG

Replies