Mar 11 2021 04:37 AM
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
Mar 12 2021 04:07 AM
Mar 12 2021 08:06 AM
Can you please explain how it works? thx
Mar 12 2021 08:42 AM
@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:
Mar 12 2021 09:44 AM
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?