Excel: Overtime Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

 

Home ->Styles ->Conditional Formatting

Conditional Formatting

Conditional formatting is a way to change the color or size of a cell, based on the results of an equation.

 

Our timesheet is tracking overtime. What if the overtime hours showed up as big, bold and green?

 

Try it: Use Conditional Formatting

Select Cell H15

Then go to the Home Tab

Look for the Styles Group.

Click on Conditional Formatting.