Hi,

This is my first post. I have Excel 2010 and I am working with a spreadsheet for lab data that has approximately 20 tabs and each tab has 1 to 8 columns of data that represents lab results. Each column has a different heading such as Calcium, Protein, Sodium, Fat, etc.
In each column is a list of data.

I am asking for help with the following:

I need to mark any data point (by underlining) that is more than 2 standard deviations from the target value. Each column has different values and criteria listed in it. Is there a way to copy and paste the conditional formating function from one column to another column much like I can copy and paste the normal calculations or statistical calculations? I am hoping that I do not have to manually run the conditional formating feature manually for each column on each spreadsheet tab..

Thank you for your help.