Overall payroll analysis

Conditional Formatting in Google Sheets

Adam Steinfurth

Instructor

Current week vs. same week prior year

Comparing years.png

Conditional Formatting in Google Sheets

Add variances

Years with variances.png

Conditional Formatting in Google Sheets

Combination of rules

Two separate conditional formatting rules:

  • Greater than 10% and $2,000?

    • =AND($E4>2000,$F4>0.1)

  • Less than -10% and $2,000?

    • =AND($E4<-2000,$F4<0.1)
Conditional Formatting in Google Sheets

Red background

Red highlighting

Conditional Formatting in Google Sheets

Both rules applied

Both rules applied

Conditional Formatting in Google Sheets

One more practice!

Conditional Formatting in Google Sheets

Preparing Video For Download...