Forum Discussion
Conditional formatting a cell
I need to format the cells below the following digit intervals as follows: I have another cell which the celles below should refer to, and if that cells number is in the interval between 6 and 9 the...
Example:
The cells value is 6. Then it is greater than or equals 6 and is smaller than or equals 9, and the value would return as 6 in the cell below 6 - 9.
If the value is 11, it would return as 11 in the cell below 10 - 13
If the value is 18 it would return as 18 in the cell below 14 - 18.
The cells value is 6. Then it is greater than or equals 6 and is smaller than or equals 9, and the value would return as 6 in the cell below 6 - 9.
If the value is 11, it would return as 11 in the cell below 10 - 13
If the value is 18 it would return as 18 in the cell below 14 - 18.