I am trying to create attention catching number pattern but I don't wan
to manually enter each color pattern formating. Is there a way where
enter a number and its associated color pattern will appear on th
number in another place ?
For example: series number in one column 1,2,3 4 ,5,6,7,8,9,10
I enter 1, 5, 7 on separate column
column 1,2,3 4 ,5,6,7,8,9,10
1, 5 & 7 's background color(pattern color) for the column will chang
to yellow.
How to associate a particular group of numbers with certain patter
color ?
Thanks..
--
Harry8
-----------------------------------------------------------------------
Harry88's Profile:
http://www.excelforum.com/member.php...fo&userid=3529
View this thread:
http://www.excelforum.com/showthread.php?threadid=55079