Hello all!

I’m trying to do a conditional format like this
=IF(A7>"",TRUE,FALSE) That the cells on this row should be shaded if the row
above has values entered, like that all the rows are clear until you enter
data in the row above, but the problem is that I also have zero values on
some columns which was before like this CELL VALUE IS LESS THEN 0, FORMAT
FONT TO WHITE and the dollar sign was white therefore invisible, but now it
turns black.

I would like it to be that even when it has the shade, the dollar sign
should not be visible (maybe by formatting the same color as the shade).

Thank you all in advance I would really appreciate if you respond ASAP