Automatically format cells (e.g. change font color) based on a certain condition? Use the conditional Formatting. Conditional formatting allows you to set rules for cell formatting. If the rules (conditions) are met, then the formatting is applied. To do this:
1. Select the cells to be formatted
2. On the [Home] tab of the ribbon click [Conditional Formatting]
3. Leave the first drop-down box set to ‘Cell Value Is’
4. In the second drop-down box, choose one of the operators. Example, choose ‘greater than’
5. In the text box, type a number or a cell reference. In this example, type the value you want to check – 499999.
6. Click the Format button
7. On the Patterns tab, select a colour for the conditional formatting — blue, in this example.
You can also choose a Font format or a cell Border.
8. Click OK.
9. To add another conditional format, click the Add button.
10. Repeat steps 3 to 8, using the values and colours for the second conditional format.
11. Click OK, to return to the worksheet.
Do you think CBDT should extend Tax Audit Report and relevant ITR Due Date? Please Comment, Vote, Retweet and Like.— Tax Guru (@taxguru_in) September 18, 2018