![]() ![]() Change this default rule by going to the Manage Rules button under the Conditional Formatting menu while the data range is selected. ![]() For values between the 33rd and 66th percentiles, an exclamation symbol is the default. This will be a 3-symbol icon set (a check mark, an X, and an exclamation mark).īy default, Excel places a check mark for values within the 67th percentile and higher, and an X for values below the 33rd percentile. Go to the Home tab > click Conditional Formatting > then choose Icon Sets and select the set which includes the check mark indicator. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |