More on what I'd like you to do:
In the attached is a version of your Reference sheet.
I'd like you to fill in column B (colours too but I can probably work those out myself) and attach the file here.

You'll see I've made a stab at Phosphorous at B47, and added various formulae in column C.
To illustrate the sort of thing I'll do in code I've highlighted cell L47 in yellow where you can type in experimental values for Phosphorus, and see in M47 the kind of text that will appear in the comment box.


Would you want the functionality where if a reading is so far positive or negative that it's nigh on physiologically impossible, you could have comments to suggest checking the validity of the result?

Attached Files

msofficeforums39829ReferenceSheet.xlsx (13.7 KB, 12 views)