Conditional Format to Enter a Value in another Cell

[kreases]

I want to conditionally format some values in a column based on the thresholds in the table below but I want the value in brackets to be entered in another cell.

Threshold
(1) Current
(2) 0-30
(3) 31-60
(4) 61-90
(5) 91-120
(6) 121-150
(7) 151-180
(8) 180+

So if the value is between say 31 and 60 in the threshold column it would automatically enter a 3 or if it was between 121 and 150 it would enter a 6, so basically the value in the brackets of the table shown above.

Can anyone help with this please, thanks

 

[philwojo]

Conditional formatting can't put values into a cell, it can only "format" a cell, hence the title.

You would need to use a formula in that other cell to test for your conditions and return the value you want based on that test.