Hi All,
I'm brand new to the forum and alhough I have been using excel 2010 extensivley I'm finally at a point where I believe I need some help. I've been looking all over the web seeing if I could find a similar solution to my problem but have come up empty handed.

Anway on to the issue:
I work with very large worksheets that contain huge amounts of laboratory data emanating from scientific instruments.
The column order (except for the Samle ID) can change dynamically and is dependant on what the instrument has been asked to read for.
The individual cell header info does not change for example Ag328 will always be Ag328, but one time it could be in column B the nexy in column Z. A header could read Ag328, Ag328ax, Cu327, Mo202, Mo204. This header is always in row 1 but it's order can change, sometimes some of the header items may noy even be there.
What I need to do is for the macro to look at what is in the header then find the last row in the speadsheet and then apply a conditional format from a set of tables which can vary from one header column to another. The conditional formating based on tables I can handle but the look up to see what is in the header is what I'm having problems with. I'm thinking I have to build some sort of array and hold it in memory.


I'll try and explain with some small amount of data.
Sample ID Ag328 Ag328ax Cu327 Mo202 Mo204 Ni321
ABC123 25 25 4500 10 10 3200
AVX547 10 10 12500 21 21 125
ZXC123 2 2 125 550 550 566

What I require is:
Highlight all the cells for Ag328 and Ag328ax that are larger than 100 and less than 500. In the case above there would be no cells that are highlighted
For Cu327 highlight all the cells that are above 3000 but less than 10000. Here the 4500 value would be highlighted.
For Mo202 and Mo204 highlight all cells that have values between 100 and 500. Here no cells would be highlighted.
For Ni321 highlight all cells between 2500 and 10000. Here one value 3200 would be highlighted.


As mentioned the above header order could change and at times some of these may not even be there for eg on another data set Cu327 may not exist.

To give you an idea the headers across the page can be as many as 80 and the number of rows can extend into the thousands.

Hope this makes some sort of sense. An I apologise for any confusion before hand.
Any help would be well apprciated.


Thanks


Ronald