Dec 01 2020 12:23 PM
Dec 01 2020 01:42 PM
Dec 01 2020 10:59 PM
Dec 02 2020 05:02 AM
You would change the less than sign "<" to greater than ">" in the formula and click on "Format" to modify the background color.
Dec 03 2020 11:42 PM
Dec 04 2020 05:09 AM
No, the "<>" symbol means when A1 does not equal to A2. To get an exactly half condition would mean adding the "=" to the greater/less than sign.
For example, if you want A1 less than or equal to 1/2 of A2, the formula would be:
A1 <= A2/2
Dec 04 2020 07:50 AM