freeriding
New Member
- Joined
- Sep 21, 2015
- Messages
- 22
Hallo! I set conditional formatting in the cells in red.
The problem is that, when the formula in the conditional formatting is not true (i set the number 5 in cell A94, so it is not blank), then only the first row of the 3 gets white (while all 3 of the rows whould be white, since the conditional formatting applies to A94:C96)
This is solved if in the formula is set $A$94 instead of $A94, but this is not convenient for me in other functions.
Is there another solution?
PS. to make it more clear:
I want that when A1 is blank, then A1:C3 is colored.
When A1 has a number, then A1:C3 is non color filled.
The problem is that, when the formula in the conditional formatting is not true (i set the number 5 in cell A94, so it is not blank), then only the first row of the 3 gets white (while all 3 of the rows whould be white, since the conditional formatting applies to A94:C96)
This is solved if in the formula is set $A$94 instead of $A94, but this is not convenient for me in other functions.
Is there another solution?
PS. to make it more clear:
I want that when A1 is blank, then A1:C3 is colored.
When A1 has a number, then A1:C3 is non color filled.