Refer
http://www.contextures.com/xlCondFormat01.html
If this post helps click Yes
---------------
Jacob Skaria
"it''''''''sh hardy" wrote:
Hey there... I'm trying to conditionally format multiple cells but am having
issues. The format painter does not work properly. Is there a way to do it
for more than one cell at a time?