IF statement for colouring cells

New Contributor

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:

4 Replies
The feature is called "conditional formating".

@vsaCOViS 

Can you please explain how it works? thx

@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:

vsaCOViS_0-1615566964641.png

Then you have to choose conditional formatting and greater then:

vsaCOViS_1-1615567185727.png

Next dialog: Greater then 0 and ok:

vsaCOViS_2-1615567296286.png

 

And in the result you get this:

vsaCOViS_3-1615567337767.png

 

 

@vsaCOViS 

Ok great. Now I'd like to go further :') ....
I have a two cells and I would like to colour them only if both the value are positives.
do you know how to do that?