Read Help and experiment with Format | Conditional Formatting
Come back with questions
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address
"craigwojo" wrote in message
...
Hi everyone,
I was just wondering on how to change the color of a cell within a
function.
I want to change the color from "no fill" to "bright yellow" IF the sum
of the amount is < "0", then change it to "green" if it is < "200".
Any assistance will be appreciated. :)
Thank you,
Craig
--
craigwojo
------------------------------------------------------------------------
craigwojo's Profile:
http://www.excelforum.com/member.php...o&userid=13767
View this thread: http://www.excelforum.com/showthread...hreadid=276111