Hello,
I have a sheet that contains numerous parameters (up to 30) in a column. Each parameter has its own row in which I input data to and then screen against the applicable standards. I want to create a macro that goes through the list of parameters (in a fixed column) and for that row that the parameter is in run parameter specific formulas to change the fill or font color based on the user input concentration.
I'm familiar with all the formulas to change color based on value.. etc., but I could use a pointer on how to write the code that will go through the column look for specific text and let me write a bunch of if statements for that row containing the specific text. Ideally, the formulas I would run for that row would start at a fixed column and end at the column that contains any values.
I've done this in conditional formatting but paste/overwrite makes it useless for some users.
Thank you in advance,
I have a sheet that contains numerous parameters (up to 30) in a column. Each parameter has its own row in which I input data to and then screen against the applicable standards. I want to create a macro that goes through the list of parameters (in a fixed column) and for that row that the parameter is in run parameter specific formulas to change the fill or font color based on the user input concentration.
| acenaphthene | Acenaphthene user input concentration - run specific formula (fill or font color change) here because we are in "acenaphthene" row | Acenaphthene user input concentration - run specific formula (fill or font color change) here because we are in "acenaphthene" row | Acenaphthene user input concentration - run specific formula (fill or font color change) here because we are in "acenaphthene" row |
| acenaphthylene | Acenaphthylene user input concentration - run specific formula (fill or font color change) here because we are in "acenaphthylene" row | Acenaphthylene user input concentration - run specific formula (fill or font color change) here because we are in "acenaphthylene" row | Acenaphthylene user input concentration - run specific formula (fill or font color change) here because we are in "acenaphthylene" row |
| anthracene | etc | etc | etc |
| benz(a)anthracene | etc | etc | etc |
| benzo(a)pyrene | etc | etc | etc |
| benzo(b+j)fluoranthene | etc | etc | |
| benzo(g,h,i)perylene | etc | etc | etc |
I'm familiar with all the formulas to change color based on value.. etc., but I could use a pointer on how to write the code that will go through the column look for specific text and let me write a bunch of if statements for that row containing the specific text. Ideally, the formulas I would run for that row would start at a fixed column and end at the column that contains any values.
I've done this in conditional formatting but paste/overwrite makes it useless for some users.
Thank you in advance,
