Forum Discussion

opare1109's avatar
opare1109
Copper Contributor
Mar 11, 2021

IF statement for colouring cells

Hello world! I don't know if it is possible but I hope so:

I would like to give my excel sheet a command for colouring selected cells ONLY IF the value in that cell is greater than zero.

thanks to everyone will give me a hint:lol:

      • vsaCOViS's avatar
        vsaCOViS
        Copper Contributor
        Mar 12, 2021

        opare1109 :
        My excel is in german. But you will find the buttons at the same place:
        First you have to mark the area to be colored:

        Then you have to choose conditional formatting and greater then:

        Next dialog: Greater then 0 and ok:

         

        And in the result you get this:

         

         

Resources