Programming Examples
In a spreadsheet, create a table with the following data for monthly sales
In a spreadsheet, create a table with the following data for monthly sales (in Rs.):
Month | Sales (in Rs.) |
January | 6000 |
February | 4500 |
March | 7000 |
April | 3200 |
May | 5200 |
Use conditional formatting to:
- Color cells green if sales are greater than 5000.
- Color cells yellow if sales are between 3000 and 5000.
- Color cells red if sales are below 3000.
Output/ Explanation: