(Perhaps) Conditional Formatting - Tabs

Originally Posted by FDibbins

changing the cell color is easy, use conditional formatting...home tab, styles/conditional formatting, select new rule, select "format only cells that contain, select "greater than"


As for changing the tab color, that will require VBA, and my VBA sucks

Well, you at least know of the EXISTENCE of VBA mate, which puts you a step above me, rest assured!