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.
0 Comments
Leave a Reply. |