Advance Excel For Team Management:

How to Update tasks through :

a. How to create a drop down list in excel?

1. Open a spreadsheet in Google Sheets.
2. Select the cell or cells where you want to create a drop-down list.
3. Click Data  Data validation.
4. Next to "Criteria," choose an option:
   • List from a range: Choose the cells that will be included in the list.
   • List of items: Enter items, separated by commas and no spaces.
5. The cells will have a Down arrow. To remove the arrow, uncheck "Show dropdown list in cell."
6. If you enter data in a cell that doesn’t match an item on the list, you’ll see a warning. If you want people to only enter items from the list, choose "Reject input" next to "On invalid data."
7. Click Save.

b. How to change the colour of the cells using Conditional Formatting?

1. Open a spreadsheet in Google Sheets.
2. Select the cells you want to apply format rules to.
3. Click Format  Conditional formatting. A toolbar will open to the right.
4. Create a rule.
   • Single color: Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met.
   • Color scale: Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow .
5. Click Done.