this is very helpful - thank you!
"John" wrote:
this might help
http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get
Ice Hockey rules (especially the Wightlink Raiders)
"Min" wrote:
I want to change the colour of individual cells according to certain criteria.
Conditional formatting is ideal but it will only allow me 3 conditions - I
need 16!