Change the color of a cell based on a calculated value

[mkalavitz]

Hello,

I am putting a simple equation into a cell to return a result in the cell. Is there anyway to make the cell color turn a color ("green") when a specific value is calculated?

For example, the calcuation is doing a percent calcuation. I want the cell color to be green if the percentage is greater than 50% and red in color when the percentage value is below 50%...Any advice??

This is the calculation that I have in the cell: =(C4-D4)/((C4+D4)/2)

Thanks in advance for any advice...

Mike

[Gary L Brown]

Use Conditional Formatting.
HTH,
--
Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"mkalavitz" wrote:

>
> Hello,
>
> I am putting a simple equation into a cell to return a result in the
> cell. Is there anyway to make the cell color turn a color ("green")
> when a specific value is calculated?
>
> For example, the calcuation is doing a percent calcuation. I want the
> cell color to be green if the percentage is greater than 50% and red in
> color when the percentage value is below 50%...Any advice??
>
> This is the calculation that I have in the cell: =(C4-D4)/((C4+D4)/2)
>
> Thanks in advance for any advice...
>
> Mike
>
>
> --
> mkalavitz
> ------------------------------------------------------------------------
> mkalavitz's Profile: http://www.excelforum.com/member.php...fo&userid=8028
> View this thread: http://www.excelforum.com/showthread...hreadid=401188
>
>