how do i change cell colour by value in excell
 

I am trying to varie the colour of a cell depending on the returned value of
that cell. The cell has a few simple sums within it culd anybody help with a
very inexperianced user
Thanks

how do i change cell colour by value in excell
 

Hi,
You can use conditional formating, let's say your cell whit the formula is
in A1 and the cell you want to change color in A2, if the result you are
looking for is if that value is greater than 1 enter position yourself on
Cell A2 and in conditional formating enter A11, then choose the color

"Kram" wrote:

I am trying to varie the colour of a cell depending on the returned value of
that cell. The cell has a few simple sums within it culd anybody help with a
very inexperianced user
Thanks

how do i change cell colour by value in excell
 

Maybe this site will help you understand how it works.

http://office.microsoft.com/en-us/ex...CL100570551033

"Kram" wrote:

I am trying to varie the colour of a cell depending on the returned value of
that cell. The cell has a few simple sums within it culd anybody help with a
very inexperianced user
Thanks