Thank you for your help. though I have a lot of experience with Excel, I have never gotten into Marcos much and never VBA, so any assistance, please tell me how to do it. I am using Office 2010.

I have a workbook that tracks attendance for our employees. It has over 80 tabs on it. I am trying to make it so that if a cell value (F3) is above a number, it would change the tab color for that worksheet.

I am looking at if the cell value is over 5 = yellow, over 7 = orange, over 9 = red.

Thank you for your help!