2 Conditiaonal Formatting

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

"Bob" Thanx so much for replying,

It didnt do what I want it to do, the cell contains a formula therefore the
dollar sign is being shown and I dont want it to be visible at all, it should
only show when its a value, say it returns $1000.00, but else when the shade
i'snt there it should be (white) , when the shade is there it should be (the
color of the shade)

Again thanx so much

"Bob Phillips" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >
>
>
>