See
http://www.xldynamic.com/source/xld.CFConditions.html
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"Harley" wrote in message
...
How do I establish the color index, font & interior, of a conditional
formatted cell?