How To: Use conditional formatting for a student attendance report in Microsoft Excel

Use conditional formatting for a student attendance report in Microsoft Excel

You can use conditional formatting in Microsoft Excel to create an easy attendance report for you classroom. This can also be applied to other similar types of reports. The report in this video includes the names of the students, the total possible days of attendance, the actual amount of days attended by each student, the percentage of attendance, and their rank in the class. Just follow along with the video to see how it's done.

Have an iPhone? Check out all 200+ new features coming in iOS 13.

Get the Gadget Hacks Daily

Life hacks for your smartphone.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest