i have this conditional format:
Condition 1:
Formula =AND($R$5>=$H$5;$H$5<>0)
RED COLOR
Condition 2:
Value of cell is smaller than =$H$5
GREEN COLOR
So this works ok, but problem is when in R5 is empty cell he gives me red color but i want when cell is empty - no to have that cell colored - i want to be white as default!
How to solve this?
Condition 1:
Formula =AND($R$5>=$H$5;$H$5<>0)
RED COLOR
Condition 2:
Value of cell is smaller than =$H$5
GREEN COLOR
So this works ok, but problem is when in R5 is empty cell he gives me red color but i want when cell is empty - no to have that cell colored - i want to be white as default!
How to solve this?