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