Forum Discussion
Conditional Formatting
Hi All, Is it possible to conditional format a cell to change colour when it is less than half of another cell. For example. Cell A1 total is 11 Cell A2 total is 25 I want A1 to colour red i...
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
Thank you so much for this. Much appreciated 👍