Conditional Formatting

Question

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 11Cell A2 total is 25I want A1 to colour red if it is less than half of cell A2.Hope that makes sense.Thanks

adversi · Answer

James2185&nbsp;Yes, you have to use a formula as the Rule Type. See the screenshot:&nbsp;

james2185 · Answer

That's great, and if I was to do the opposite, everything above half to turn green, how would the formula look like? Sorry but I'm so new to this 🤦

adversi · Answer

James2185&nbsp;You would change the less than sign "&lt;" to greater than "&gt;" in the formula and click on "Format" to modify the background color.&nbsp;

james2185 · Answer

And if A1 was exactly half of A2 for example,A1 11A2 22Would I show it as=A1&lt;&gt;A2

adversi · Answer

James2185&nbsp;No, the "&lt;&gt;" 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.&nbsp;For example, if you want A1 less than or equal to 1/2 of A2, the formula would be:A1 &lt;= A2/2

Forum Discussion

Conditional Formatting

6 Replies

Resources