I might add that if you are doing this on a regular basis it is much better
using an add-in then an event macro


--


Regards,


Peo Sjoblom



"Peo Sjoblom" wrote in message
...
What can I say, I just went to Bob's site and downloaded it and it worked
fine. I had no problems extracting both files.


--


Regards,


Peo Sjoblom


"steve-o" wrote in message
...
Thanks for your answer.

I tried downloading the file from the first link and winzip gave me the
following message:

Cannot Open File: it does not appear to be a valid archive. If you
downloaded this file, try downloading it again."

is there another link where I could download it?

Thanks ,

"Peo Sjoblom" wrote:

If you have Excel 2007, yes. If not your would need VBA


http://www.xldynamic.com/source/xld.....Download.html


unless it would fit these requirements

http://www.mcgimpsey.com/excel/conditional6.html


--


Regards,


Peo Sjoblom


"steve-o" wrote in message
...
Hi All:

I would like to use conditional formatting on a spreadsheet where a
row in
a
spread sheet's color depends on the value of one of the cells on a
row,
called the status cell. However, I would like to have six colors
representing six different values in the status cell. Is there a way
to
implement this conditional formatting?

Thanks in advance,

steve-o