I have a column of calculated results. I have applied conditional formatting
to alternate colours per line, then to change the font colour for values
between 90 and 95% and also to change colour and bold values under 90%. It is
working fine on all but the first three values in the column. I have copied
from the cells below and still get the same issued. I can't see any
difference in the format or properties of these particular cells. Any
thoughts?

OK, Answering my own question, it appeard it only works where the background
colour format isn't applied. Is there a way for bot formula and cell value
conditions to be considered?

"Dean F" wrote:

I have a column of calculated results. I have applied conditional formatting
to alternate colours per line, then to change the font colour for values
between 90 and 95% and also to change colour and bold values under 90%. It is
working fine on all but the first three values in the column. I have copied
from the cells below and still get the same issued. I can't see any
difference in the format or properties of these particular cells. Any
thoughts?

It is probably relative referencing, but we can tell better if you show us
the CF formula.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dean F" wrote in message
...
I have a column of calculated results. I have applied conditional
formatting
to alternate colours per line, then to change the font colour for values
between 90 and 95% and also to change colour and bold values under 90%. It
is
working fine on all but the first three values in the column. I have
copied
from the cells below and still get the same issued. I can't see any
difference in the format or properties of these particular cells. Any
thoughts?

1. formula is: row()=even(row()) - format: pattern/colour blue
2. cell value is: between .9 and .95 - format: font red
3. cell value is: less than .9 - format font red and bold italic

Thx

Dean

"Bob Phillips" wrote:

It is probably relative referencing, but we can tell better if you show us
the CF formula.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dean F" wrote in message
...
I have a column of calculated results. I have applied conditional
formatting
to alternate colours per line, then to change the font colour for values
between 90 and 95% and also to change colour and bold values under 90%. It
is
working fine on all but the first three values in the column. I have
copied
from the cells below and still get the same issued. I can't see any
difference in the format or properties of these particular cells. Any
thoughts?

Can you explain this bit

.... Is there a way for both formula and cell value conditions to be
considered?


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dean F" wrote in message
...
1. formula is: row()=even(row()) - format: pattern/colour blue
2. cell value is: between .9 and .95 - format: font red
3. cell value is: less than .9 - format font red and bold italic

Thx

Dean

"Bob Phillips" wrote:

It is probably relative referencing, but we can tell better if you show
us
the CF formula.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dean F" wrote in message
...
I have a column of calculated results. I have applied conditional
formatting
to alternate colours per line, then to change the font colour for
values
between 90 and 95% and also to change colour and bold values under
90%. It
is
working fine on all but the first three values in the column. I have
copied
from the cells below and still get the same issued. I can't see any
difference in the format or properties of these particular cells. Any
thoughts?

It seems once the 'row()=....' condition is met, the subsequent conditions
aren't considered. I want to be able to set conditions based on that formula,
as well as additional conditions based on the cell value.

"Bob Phillips" wrote:

Can you explain this bit

.... Is there a way for both formula and cell value conditions to be
considered?


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dean F" wrote in message
...
1. formula is: row()=even(row()) - format: pattern/colour blue
2. cell value is: between .9 and .95 - format: font red
3. cell value is: less than .9 - format font red and bold italic

Thx

Dean

"Bob Phillips" wrote:

It is probably relative referencing, but we can tell better if you show
us
the CF formula.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dean F" wrote in message
...
I have a column of calculated results. I have applied conditional
formatting
to alternate colours per line, then to change the font colour for
values
between 90 and 95% and also to change colour and bold values under
90%. It
is
working fine on all but the first three values in the column. I have
copied
from the cells below and still get the same issued. I can't see any
difference in the format or properties of these particular cells. Any
thoughts?

OK I see. You are right, it stops on a met condition. You need to AND the
conditions to get two at once

=AND(cond1,cond2)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dean F" wrote in message
...
It seems once the 'row()=....' condition is met, the subsequent conditions
aren't considered. I want to be able to set conditions based on that
formula,
as well as additional conditions based on the cell value.

"Bob Phillips" wrote:

Can you explain this bit

.... Is there a way for both formula and cell value conditions to be
considered?


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dean F" wrote in message
...
1. formula is: row()=even(row()) - format: pattern/colour blue
2. cell value is: between .9 and .95 - format: font red
3. cell value is: less than .9 - format font red and bold italic

Thx

Dean

"Bob Phillips" wrote:

It is probably relative referencing, but we can tell better if you
show
us
the CF formula.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dean F" wrote in message
...
I have a column of calculated results. I have applied conditional
formatting
to alternate colours per line, then to change the font colour for
values
between 90 and 95% and also to change colour and bold values under
90%. It
is
working fine on all but the first three values in the column. I
have
copied
from the cells below and still get the same issued. I can't see
any
difference in the format or properties of these particular cells.
Any
thoughts?