Make up a data that includes any dates, highlight all weekdays in red. Highlight in blue all days that occur in the first 10 days of the month. Which color takes precedence when both colors are applied to one cell?

Suppose each worker in Microsofts finance department has been assigned to one of four groups. The supervisor of each group has rated each worker on a 010 scale, and each worker has rated his satisfaction with each of the four groups. Based on the group to which each worker is assigned, highlight the supervisor rating and the worker satisfaction rating for each worker.

USE EXCEL