Ultimate Selector
Board Regular
- Joined
- Dec 15, 2013
- Messages
- 153
I simply want to conditionally format a number in one cell if it is at least 2 times (or More) lower than the cell to the left of it. Here are my exact layout grid numbers. What would be the exact formula for this?
So K7 is 2x's LOWER than J7. I want to format it a certain other color ...
What would be the exact formula for this? as I would do it for all numbers compared from K to J array going from right to left!
Thanks in advance.
Regards,
U.S.
J-7:J-12 ... K-7:K-12
<tbody>
[TD="class: xl64"]5.0[/TD]
[TD="class: xl65, width: 63"]2[/TD]
[TD="class: xl64"]20.6[/TD]
[TD="class: xl65"]38[/TD]
[TD="class: xl64"]15.4[/TD]
[TD="class: xl65"]28[/TD]
[TD="class: xl64"]7.5[/TD]
[TD="class: xl65"]11[/TD]
[TD="class: xl64"]1.5[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl64"]2.5[/TD]
[TD="class: xl65"]3[/TD]
</tbody>
So K7 is 2x's LOWER than J7. I want to format it a certain other color ...
What would be the exact formula for this? as I would do it for all numbers compared from K to J array going from right to left!
Thanks in advance.
Regards,
U.S.
J-7:J-12 ... K-7:K-12
<tbody>
[TD="class: xl64"]5.0[/TD]
[TD="class: xl65, width: 63"]2[/TD]
[TD="class: xl64"]20.6[/TD]
[TD="class: xl65"]38[/TD]
[TD="class: xl64"]15.4[/TD]
[TD="class: xl65"]28[/TD]
[TD="class: xl64"]7.5[/TD]
[TD="class: xl65"]11[/TD]
[TD="class: xl64"]1.5[/TD]
[TD="class: xl65"]1[/TD]
[TD="class: xl64"]2.5[/TD]
[TD="class: xl65"]3[/TD]
</tbody>
Last edited: