Thank you; this worked great!
"Peo Sjoblom" wrote:
If you have excel 2007 you can use conditional formatting, earlier versions
would need VBA
http://www.xldynamic.com/source/xld.....Download.html
--
Regards,
Peo Sjoblom
"Cindy" wrote in message
...
"Cindy" wrote:
How do I get 1-5 entered as a value to format with each five numbers
having
its own background color?