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

Formatting Options

There are a couple of steps to creating the Conditional Formatting.

 

Cell Rules Greater Than 0:

Enter 0 (zero) for the amount and select Green Fill with Dark Green Text from the list and click on OK.

 

Cell Rules Less Than 0: Repeat the experiment for results Less Than 0 (zero), but this time choose the red formatting option.