If you have been able to get this to work with the one cell, then all
you need to do is copy the FORMAT and paste it into the other cells. To
do this, you can either use the format painter (this is an icon that
looks like a 2 inch paintbrush). Highlight the cell that works with the
conditions and click on the format painter and then put the cursor on
the cell you want to format with the conditions.
The alternative way is to Ctrl-C copy the cell that has had the
conditionning done and Paste Special/FORMATS the new cells

Cheers


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=398543