Simon Lloyd wrote:
Thats because when you use conditional formatting your expression looks
something like this =$A$1=""fred", notice the $ it makes things an absolute reference if your expression
looked like this =$A1=""fred" it will copy down fine!

Regards,
Simon


--
Simon Lloyd

------------------------------------------------------

Thanks for the help.

Henry