Change Color on an IF statement
 

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

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