Yes, use that formula in conditional formatting. See
http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



wrote in message
...
is it possible to change the color of all cells that contain a formula
or are part of a formula???

if so, how would i do that?