Thanks for taking the time to give it a go but it doesn't seem to be working .

Is this even possible?

I am looking for the ranges to change on each material listed when the "Grade" in C6 changes.

All limits corresponding to this grade are on the "GradeSpecs" sheet.

Both upper and lower limits need to be in place, so that when a number that is entered into one of the different materials columns doesnt comply to the spec on the "GradeSpecs" sheet, the cell or text turns a different colour.

Thanks again