![]() ![]() ![]() The green rule set the fill (>75000), then the yellow rule (>50000) can’t change the color, but it can change the font, so it results in a green fill with red font.The Green and Red rules do not change the font, but all rules change the fill color.Move the yellow rule up and all the green goes away.Notice the rules are applied top to bottom.Select D4:D13, go to the Home tab > Conditional Formatting > Manage Rules.Why do we have green cells with red font when we didn’t set a rule that way?.=D4>75000 to apply a light green background.Enter =D450000 to apply a yellow background with a dark red font.Choose “use a formula to determine which cells to format”.Select D4:D13, go to the Home tab > Conditional Formatting > New Rule. ![]() Unfortunately, Excel’s defaults won’t cover every scenario we need, so we have the ability to build our own rules to suit. When to useĬonditional formatting is used to highlight key pieces of data that meets certain conditions. Creating custom conditional formatting rules based off formulas. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |