Microsoft Office Tutorials and References
In Depth Information
in a data
Note that if you click the Greater Than button on the Quick Analysis palette,
Excel displays a Greater Than dialog box where you specify the threshold
value in the Format Cells That Are Greater Than text box, as well as select the
color of the formatting for all the cells above that threshold in the drop-down
list to its right.
With all the other kinds of conditional formats (Data Bars, Color Scale, Icon
Set, and Top 10%), Excel just goes ahead and applies the first (default) option
for that kind of formatting found on the Conditional Formatting button’s
drop-down menus on the Ribbon.