| Description |
Conditional formatting treats data like character. For example: I have a panel that lists customers and their tech excel ticket count. I want the customers who have a ticket count > 100 to be boldfaced. All above 100 will be boldfaced, but so will some less than 100.
Like 8, 80, 20, 21, etc would be boldfaced. However, 1,10,19 would all be not bolded.
This is because the comparison is going left to right, position by position, rather than treating it as a whole number.
This is the setting:
!pastedImage_d25677_0.png!
Most of these rows are ok, but everything <= 100 should not be bold:
!pastedImage_d25677_1.png!
The should not be bold (rows that are <= 100):
!pastedImage_d25677_2.png!
Note the values with the first position > 1 are bold, and those that are <= 1 are not:
!pastedImage_d25677_3.png! The compare is only looking at position 1 rather than the whole number.
|