displayhasem.blogg.se

The result is a red flag appearing next to any values below 90.

Click OK to close the Edit Formatting Rule dialog, and then click OK to close the Conditional Formatting Rules Manager.

Change the Value to any number larger than 90 in the first row and to 90 in the second row. Change the Type to Number for the first two rows. In the Edit Formatting Rule dialog, change the Icon to “No Cell Icon” for the first two rows.Select Home Conditional Formatting, Manage Rules, Edit Rule.Go to Home, Conditional Formatting, Icon Sets, 3 Flags.To have only the red flag appear on values less than 90, follow these steps: While the flags look great, they are volatile. Any time that a value falls below 90, you want to highlight the cell.Ĭolumn A contains an icon set from the conditional formatting menu. The worksheet speed instantly improved.įigure 1 shows six different ways to flag cells. Through a group effort, we determined that replacing the traditional conditional formatting with an old custom number format created a way to flag the same cells without causing all 600,000 cells to be volatile. I was presenting at the PricewaterhouseCoopers (PwC) offices in Melbourne, Australia, for the Excel Summit South when someone in the audience had such a spreadsheet.