Checking a payroll register

Conditional Formatting in Google Sheets

Adam Steinfurth

Instructor

Checking for OT

Emp Name	Department	Reg Hrs	Reg Rate	OT Hrs	OT Rate
Leland Morgan	Marketing	44	$22	10	$33
Esther Mccormick	Administrative	35	$14	0	$21
Leon Bryan	Administrative	30	$18	3	$27
Erica Wood	Accounting	34	$20	0	$30
Calvin Norman	Production	29	$16	0	$24
Mona Hanson	Marketing	33	$24	4	$36
Melinda Castro	Administrative	30	$12	0	$18
Tanya Fowler	Accounting	38	$20	0	$30

Custom formula AND

=AND(C2<40,E2>0)

OT fixed

Emp Name	Department	Reg Hrs	Reg Rate	OT Hrs	OT Rate
Leland Morgan	Marketing	44	$22	10	$33
Esther Mccormick	Administrative	35	$14	0	$21
Leon Bryan	Administrative	30	$21	0	$32
Erica Wood	Accounting	34	$20	0	$30
Calvin Norman	Production	29	$16	0	$24
Mona Hanson	Marketing	33	$28	0	$42
Melinda Castro	Administrative	30	$12	0	$18
Tanya Fowler	Accounting	38	$20	0	$30

Range of pay rates

No production employees

Text contains

Remove production

Payroll report is done!

Conditional Formatting in Google Sheets