The value is then used to lookup from a table to produce the colour i.e. X=3 therefore show the text green in another cell.
However, the variable Y needs to be copied into other places in the workbook
I.e. one place might have Y as 0.6, whereas another place may have Y was 0.4
I was wondering if it would be possible to therefore embed a formula into any location and run it so that the formula will use the same X values list from 1-10, but vary to Y value to recalculate calculate Z until the criteria is met (X*Y<=1)?
I hope this makes sense, any help is much appreciated!