Question

In a new worksheet , create a table and insert the following information. Use different fonts for different columns. 1. Names of people (at least 25) 2. Their ages 3. Number of years they have worked 4. Salary per month 5. Show housing, medical, travel and hardship allowances, in columns Page 10 B. Using the table to do the following: 1. (a) Calculate the total salary for each person and grand total for all persons.

Answer 1

Answer:

Select the cells you want to format. You can select one column, several columns or the entire table if you want to apply your conditional format to rows.

Tip. If you plan to add more data in the future and you want the conditional formatting rule to get applied to new entries automatically, you can either:

Convert a range of cells to a table (Insert tab > Table). In this case, the conditional formatting will be automatically applied to all new rows.