How do you set a cell value to change colors based on the value input within
a cell? I have received an excel spread sheet that the shading changes from
green to yellow or red based on percent

Hi

this is done through conditional formatting (found on the format menu) -
have a look at help for more details, or if you'ld like assistance with
setting it up, post back with the criteria and cell references you want to
use.

Cheers
JulieD

"d.rogers59" wrote in message
...
How do you set a cell value to change colors based on the value input
within
a cell? I have received an excel spread sheet that the shading changes
from
green to yellow or red based on percent

"JulieD" wrote:

Hi

this is done through conditional formatting (found on the format menu) -
have a look at help for more details, or if you'ld like assistance with
setting it up, post back with the criteria and cell references you want to
use.

Cheers
JulieD

"d.rogers59" wrote in message
...
How do you set a cell value to change colors based on the value input
within
a cell? I have received an excel spread sheet that the shading changes
from
green to yellow or red based on percent


This helped me so much, THANK YOU

you're welcome and thanks for the feedback

"d_rogers59" wrote in message
...


"JulieD" wrote:

Hi

this is done through conditional formatting (found on the format menu) -
have a look at help for more details, or if you'ld like assistance with
setting it up, post back with the criteria and cell references you want
to
use.

Cheers
JulieD

"d.rogers59" wrote in message
...
How do you set a cell value to change colors based on the value input
within
a cell? I have received an excel spread sheet that the shading changes
from
green to yellow or red based on percent


This helped me so much, THANK YOU