Conditional formatting a cell

Copper Contributor

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 number in the cell should be placed in the cell below 6 - 9. If on the other hand the number is between 10 and 13 it should be placed in the cell below 10 - 13 and so on.

6 - 910 -1314 - 18
   

 

How do I do this?

1 Reply
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.