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?