Returning a specific value in a cell

[chuickie77]

Hi there

I have a 9 box grid, each box has a value 1 to 9.
I want each box to highlight its value if conditions are met in other cells.

Example.

1. If 'A' <1.49 AND 'B' <1.49 then I want box 1 in the 9 box grid to show value '1'.
2. If 'A' >2.5 AND 'B' >2.5 then I want box 9 in the 9 box grid to show value '9'

the remaining boxes will follow a similar pattern.

What would be the formula need to be in example 1 and example 2?
Thanks
Paul

 

[chuickie77]

I should say as well that if the conditions are not met in example 1 or 2 then the cell should remain blank.

Really appreciate your time on this.
Thanks
Paul