Forum Discussion
To understand formatting rules
Hi, I don't understand what is the operation that excel does when you have this list of number with conditional formating : The rule for formatting is this : But I don't manage...
Hi Paul,
You min value is 200.1 and max one is 245.3. The difference is 45.2. 33% of it is about 14.92; 67% - 30.28
With your rule all values which are less than (200.1+14.92=215.02) will be with green arrow; and one which are greater than (200.1+30.28=230.38) will be with red arrow, the rest with yellow ones.