# Change the color of a cell based on a calculated value

1. ## Change the color of a cell based on a calculated value

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)

Mike  Register To Reply

2. ## RE: Change the color of a cell based on a calculated value

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

"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)
>
>
> Mike
>
>
> --
> mkalavitz
> ------------------------------------------------------------------------
> mkalavitz's Profile: http://www.excelforum.com/member.php...fo&userid=8028
>
>  Register To Reply