Are you asking for the formula to use or did 'confused' answer your question?

If you need the formula, here it is:

Select A1, and go into conditional formatting. For the first condition enter:

=IF(A1-B110,TRUE,FALSE)

Then make the formatting green.

For condition 2 write this formula:

=IF(A1-B1<10,TRUE,FALSE)

Then make this formatting red.

I'm not sure what you want to happen if A1-B1=10, but you can make the
necessary changes in the formula.
--
Regards,

DavidB


"kpekarek" wrote:

I am tring to use the conditional formating to change the colour of a cell
depending on the value.
For exemple I want the value in A1 to turn green if the value is greater
than the value in B1 by 10 or more. And I wan the value to turn red if the
value is less then 10 or more.
I want to do this for the entire spreadsheet without having to enter in the
formula into each individual cell. Is there a way to do that?