Another option that you may be interested in is colouring cell contents
based on what sort of info they contain eg formula, constant, inputs
etc. If so, check out Aaron's colour code macro:
http://www.xl-logic.com/xl_files/vba/color_code.zip
which is listed on his page:
http://www.xl-logic.com/pages/vba.html

hth
Rob Brockett
NZ

Thanks, Rob! This is exactly the purpose I need it for. I want to use a
formula which detects if a formula is used in a current cell, in order to
apply conditional formatting, so those cells with formula would show up
differently (and the user would have a choice to either overwrite them with
values, or leave them with calculated defaults).

Thank you for your reply!

Hi
Thanks for the feedback, pleased I could help.
I hope it works as you want/expect it to - from memory, it permanently
overwrites the other formatting that you have on your sheets.

Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=543604