conditional formatting

Hallo! I set conditional formatting in the cells in red.

Untitled.jpg

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)

Untitled2.jpg

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?

If I'm not mistaken, the formula you provide is used to check each cell in the range provided in the "Applies to" and then highlights only the ones that match that condition.

If you can provide a sample file im sure others can chime in and help.

So just to be clear, in the file you provided, if anything is entered into any cell within the range (A1:C3) that whole range is to be cleared of color?

if so check this update to your file.

Here is updated file, take a look

Can you provide a better sample file, one that has additional scenarios that you are trying to account for?