OBJECTIVE: I select a range of cells. I want a macro I can run that
changes the color of the text based on 3 criteria:
(1) if a numeric value w/o an = sign or any mathematical operators,
then RED
(2) if a forumla w/ an = sign, but no other operators, then GREEN
(3) if a formula w/ an = sign and operators, then BLUE
Can anyone post this?
Thanks.
- Jim
--
James C
------------------------------------------------------------------------
James C's Profile:
http://www.excelforum.com/member.php...o&userid=12114
View this thread:
http://www.excelforum.com/showthread...hreadid=395347