Forum Discussion

Copper Contributor

Dec 01, 2020

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...

excel

adversi

Iron Contributor

Dec 01, 2020

James2185

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

James2185
Copper Contributor
Dec 02, 2020
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
  Iron Contributor
  Dec 02, 2020
  James2185
  You would change the less than sign "<" to greater than ">" in the formula and click on "Format" to modify the background color.
  - James2185
    Copper Contributor
    Dec 04, 2020
    And if A1 was exactly half of A2 for example,
    A1 11
    A2 22
    
    Would I show it as
    =A1<>A2