Firstly, you only need a formula of

=A7""

as that will resolve to TEUE or FALSE and CF looks for True or False.

As to the colour, just set the font colour to the same as the pattern with
a formula of

=AND(A7"",A8<0)

--
HTH

Bob Phillips

"Benj" wrote in message
...
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