IF statement for colouring cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2202323%22%20slang%3D%22en-US%22%3EIF%20statement%20for%20colouring%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2202323%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20world!%20I%20don't%20know%20if%20it%20is%20possible%20but%20I%20hope%20so%3A%3C%2FP%3E%3CP%3EI%20would%20like%20to%20give%20my%20excel%20sheet%20a%20command%20for%20colouring%20selected%20cells%20ONLY%20IF%20the%20value%20in%20that%20cell%20is%20greater%20than%20zero.%3C%2FP%3E%3CP%3Ethanks%20to%20everyone%20will%20give%20me%20a%20hint%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%400277EEB71C55CDE7DB26DB254BF2F52B%2Fimages%2Femoticons%2Flaugh_40x40.gif%22%20alt%3D%22%3Alol%3A%22%20title%3D%22%3Alol%3A%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2205021%22%20slang%3D%22de-DE%22%3ERE%3A%20IF%20statement%20for%20coloring%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2205021%22%20slang%3D%22de-DE%22%3EThe%20feature%20is%20called%20%22conditional%20formating%22.%3C%2FLINGO-BODY%3E
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?