Quote a range ...

Hi.
I am collating medical test results into a sheet from my online access to a hospital (their system incredibly doesn't allow a data download!) and want to quote the results in one column and the ranges in another, and then apply some conditional formatting to show which results are outside range, and also perhaps have coloured data bars to give a visual representation of the results. Is there any way to quote a range in one cell and to which one can then refer i.e. can I write 2.2-2.6 in one cell and have Excel recognise that 2.2 is the minimum, and 2.6 is the maximum, or do I have to have the minimum in one cell and the maximum in another, and if I want them to appear as '2.2-2.6', I need to use a formula, e.g. 'A2&"-"&B2'?
TIA

It would be easier to have the minimum in one column and the maximum in another column (which could be hidden) and then combine them using a formula like you suggest (for visual amenity), otherwise you would need to take the characters to the left of the hyphen, and turn them into numbers (and similar for characters to the right of the hyphen), before you could compare these to your bottom and top values. You might need to use the TEXT function in your formula to ensure a consistent number of decimal places.

Hope this helps.

Pete

Thanks both. I think I will run with the min and max values in separate cells as that'll give the simplest and cleanest results. It does also align with the general data management idea of having the smallest amount of definable data in one cell ... like title, first_name, surname etc all separate, which can then be combined if need be.
Happy days!