Fields in Excel automatically highlight - for what?
Excel: fields Highlighted Excel: fields Highlighted With the automatic selection of cells in Excel, it is still easier, documents, and plans to evaluate and errors or problems to be detected. For example, you can create task lists and get a colored Feedback, who has his number of hours has passed.Cells automatically mark in color: create rules
Through the so-called rules, you can define values for which a cell can be marked.
- First, select the rows and/or columns, the rule should be taken into account. Drag the Cursor over the corresponding cells.
- Then select the "Start"tab, the Option "Conditional formatting".
- Under the Option "rules to Highlight cells", you will find different ways to define rules, including, for example, "greater than", "less than" or between two values.
- Depending on which option you select in the new dialog box, enter numeric values. Then you can click on the right side of the window, choose a color. The Change will be broadcast live on the selected area will be updated.
- Confirm your rule by clicking on the button "OK" button.
If you want a rule to edit or even delete, proceed as follows.
- Under the tab "Conditional formatting" select the bottom Option "manage rules".
- Then a window opens in which all active rules. Select the appropriate rule.
- Click on the Minus button to add the rule to delete, or click on "edit rule"to the values or the rule to edit.
Glen Johnson
I'm Glen Jonhson. A full time Technology Blogger.
Website:
https://www.socialworldtips.com
No Comment to " Excel: fields automatically mark in color "