In Excel, use formulas in conditional formatting to do more than you can with the built-in rules. For example, format blank cells, or see which salespeople are selling above average, or track who has received birthday greetings from you. In Excel, if you fill color in the range cells more than twice continuously, and when you go on next cell by pressing Enter key, the cell will be auto filled with same color, too. Sometimes, the auto fill color is annoying for you. In Excel, if you fill color in the range cells more than twice continuously, and when you go on next cell by pressing Enter key, the cell will be auto filled with same color, too. Sometimes, the auto fill color is annoying for you. Now I tell you the method on stopping auto fill color in Excel. Recommended Productivity Tools.
Conditional formatting quickly highlights important information in a spreadsheet. But sometimes the built-in formatting rules don’t go quite far enough. Adding your own formula to a conditional formatting rule gives it a power boost to help you do things the built-in rules can’t do. Create conditional formatting rules with formula
For example, let’s say a doctors' office wants to track their patients’ birthdays to see whose birthday is coming up and then mark them as having received a Happy Birthday greeting from the office. In this worksheet, we see the information we want by using conditional formatting, driven by two rules that each contain a formula. The first rule, in column A, formats future birthdays, and the rule in column C formats cells as soon as “Y” is entered, indicating that the birthday greeting has been sent. To create the first rule:
To create the second rule:
Try it outYou can copy the following table to a worksheet in Excel – be sure to paste it into cell A1. Then, select cells D2:D11, and create a new conditional formatting rule that uses the formula below. =COUNTIF($D$2:$D$11,D2)>1 When you create the rule, make sure it applies to cells D2:D11. Set a color format to be applied to cells that match the criteria (that is, there is more than one instance of a city in the D column – Seattle and Spokane).
Need more help?Excel Color Fill ShortcutYou can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice. See AlsoComments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |