|For data purposes, I have a cell with a value "12.008". This is a fixed value. In the following cell, I will enter a value that is close to this number. If this cell value is greater than 0.125, above or below the previous cell, then I need the value entered to be RED. If it falls within the range of 0.125 above or below, the need the value to be BLACK.|
example: cell1(12.008), cell2(12.110).....True, remains BLACK b/c it is within the range of 0.125, above or below.
example: cell1(11.523), cell2(11.950).....False, text entered becomes RED b/c it is outside of the accepted range of 0.125, above or below.
Any help is greatly appreciated!