Forum Discussion
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 ...
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:
