Hi,
Just apply conditional formatting with condition 1 as Cell value is greater
than 50, format it to green, and condition 2 as Cell value is less than 50,
format it to green.

What is the different sheet in your thread title? conditional formatting
based on a different sheet requires you to define a named range.

Dave

"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