True True True never never in True False True True False True 6 6 12 True False True 12 True False 0 0 10 True False True end 1 0 0 0 True False True 6 12 True False True Apply Style: True style 0 0 2 False True New Style... 1 2 False True Enter a value: 0 0 3 3 True True True True 0 4 True True True True 1 4 True True True True 2 4 False False True 0 True 0 5 False False True 0 True 1 5 False False True 0 True 2 5 More Options... True True True 1 6 False True Automatic Min Max Percentile Value Percent Formula 0 1 False True Automatic Min Max Percentile Value Percent Formula 1 1 False True Automatic Min Max Percentile Value Percent Formula 2 1 True False 0 7 3 False True Minimum colscalemin 0 0 False Maximum colscalemax 2 0 True True never never in True False True False Example 2 2 0 2 True False 12 True False True is equal to is less than is greater than is less than or equal to is greater than or equal to is not equal to is between is not between is duplicate is not duplicate is in top N elements is in bottom N elements is in top N percent is in bottom N percent is above average is below average is above or equal average is below or equal average is error is not error begins with ends with contains does not contain 1 0 False Today Yesterday Tomorrow Last 7 days This week Last week Next week This month Last month Next month This year Last year Next year 1 1 False Color Scale (2 Entries) Color Scale (3 Entries) Data Bar Icon Set 1 2 True True True True 1 3 2 True False All Cells Cell value Formula is Date is 0 0 4 True False True 6 True True True True 5 0 0 True True True True 5 1 0 2 0 False True 3 Arrows 3 Gray Arrows 3 Flags 3 Traffic Lights 1 3 Traffic Lights 2 3 Signs 3 Symbols 1 3 Symbols 2 3 Smileys 3 Stars 3 Triangles 3 Colored Smileys 4 Arrows 4 Gray Arrows 4 Circles Red to Black 4 Ratings 4 Traffic Lights 5 Arrows 5 Gray Arrows 5 Ratings 5 Quarters 5 Boxes 2 2 0 1