See Dave's reply using Helper cell to hold the comparison value.

Kim wrote:

Here is an example:-

Original value in the cell
A
1 50
2 70
3 80
4 55
5 60

If I change cell A1 to 55 it should turn green.
If I change cell A2 to 60 is should turn red.
If I change cell A3 to 75 it should turn red.

Regards,
Kim

"Bob I" wrote:


You need to put the 50 into the conditional format. 50=green <50=red
therefore 50 = not red or green by default.

Kim wrote:


Hi,

Can anyone help me to find a way round the problem I've. I'm trying to set a
condition formattion to a cell where if there is any changes it will change
colour.

Example: The original value is a cell is 50. And if I change to a higher
value, the cell should turn green and if I change to lower value it will
change to red. The original cell should be no fill.

Thanks,
Kim