Conditional Formatting Comparison Criterion -- cell above

Excel 2000 (or a later version if necessary)

I know generally how to do conditional formatting, e.g., with the
compaison of the cell value with an explict (hard coded) number or
string. But how does one make the comparison between the value of the
current cell, and, e.g., the value of the cell immediately above it.
Any attempt I make to put a range address as the test value bombs.

Is there some element of code I'm missing, or does conditional
formatting not do it at all.

TIA.

Fred Holmes

If you have to use conditional formatting in cell A2 based on cell A1 then
use the following as the FORMULA IS
=A15
or whatever condition you want.

I have used this in 2003 and 2007 versions.

"Fred Holmes" wrote:

Excel 2000 (or a later version if necessary)

I know generally how to do conditional formatting, e.g., with the
compaison of the cell value with an explict (hard coded) number or
string. But how does one make the comparison between the value of the
current cell, and, e.g., the value of the cell immediately above it.
Any attempt I make to put a range address as the test value bombs.

Is there some element of code I'm missing, or does conditional
formatting not do it at all.

TIA.

Fred Holmes
.

I'm using 2007 where c/f is much better than in previous editions but I think
you should be able to handle this.
As I remember you have 2 options in 2003. Cell value (as per your
description) and formula value.
Set a formula that formats cells a2:c2 if their individual value is greater
that a1:c1
=A2:C2A1:C1
That should get you started.
Apologies if that's not what you meant
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Fred Holmes" wrote:

Excel 2000 (or a later version if necessary)

I know generally how to do conditional formatting, e.g., with the
compaison of the cell value with an explict (hard coded) number or
string. But how does one make the comparison between the value of the
current cell, and, e.g., the value of the cell immediately above it.
Any attempt I make to put a range address as the test value bombs.

Is there some element of code I'm missing, or does conditional
formatting not do it at all.

TIA.

Fred Holmes
.

Are you sure that you don't mean =A2A1 rather than =A2:C2A1:C1 ?
If you copy that across (or select the range A2:C2 before imposing the CF),
then for C2 that will become =C2C1
--
David Biddulph


"Russell Dawson" wrote in message
news
I'm using 2007 where c/f is much better than in previous editions but I
think
you should be able to handle this.
As I remember you have 2 options in 2003. Cell value (as per your
description) and formula value.
Set a formula that formats cells a2:c2 if their individual value is
greater
that a1:c1
=A2:C2A1:C1
That should get you started.
Apologies if that's not what you meant
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Fred Holmes" wrote:

Excel 2000 (or a later version if necessary)

I know generally how to do conditional formatting, e.g., with the
compaison of the cell value with an explict (hard coded) number or
string. But how does one make the comparison between the value of the
current cell, and, e.g., the value of the cell immediately above it.
Any attempt I make to put a range address as the test value bombs.

Is there some element of code I'm missing, or does conditional
formatting not do it at all.

TIA.

Fred Holmes
.

The question mention the problem to include a range and therefore that's what
I gave in my reply.

My result formats a2, b2, and c2 whenever the cell above is greater.

Of course your way format painter would extend the range where required.
I was only trying to demonstrate how a range can be input. I am keen to
learn myself by helping with other problems.

I know several of your responses have enabled me to enhance projects.
There's so much that one doesn't know and this forum is a fantastic way of
improvement.

Thanks
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"David Biddulph" wrote:

Are you sure that you don't mean =A2A1 rather than =A2:C2A1:C1 ?
If you copy that across (or select the range A2:C2 before imposing the CF),
then for C2 that will become =C2C1
--
David Biddulph


"Russell Dawson" wrote in message
news
I'm using 2007 where c/f is much better than in previous editions but I
think
you should be able to handle this.
As I remember you have 2 options in 2003. Cell value (as per your
description) and formula value.
Set a formula that formats cells a2:c2 if their individual value is
greater
that a1:c1
=A2:C2A1:C1
That should get you started.
Apologies if that's not what you meant
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Fred Holmes" wrote:

Excel 2000 (or a later version if necessary)

I know generally how to do conditional formatting, e.g., with the
compaison of the cell value with an explict (hard coded) number or
string. But how does one make the comparison between the value of the
current cell, and, e.g., the value of the cell immediately above it.
Any attempt I make to put a range address as the test value bombs.

Is there some element of code I'm missing, or does conditional
formatting not do it at all.

TIA.

Fred Holmes
.


.

Select the range and try my formula, Russell.

Glad that some of my responses have been useful. Keep learning!
--
David Biddulph


"Russell Dawson" wrote in message
...
The question mention the problem to include a range and therefore that's
what
I gave in my reply.

My result formats a2, b2, and c2 whenever the cell above is greater.

Of course your way format painter would extend the range where required.
I was only trying to demonstrate how a range can be input. I am keen to
learn myself by helping with other problems.

I know several of your responses have enabled me to enhance projects.
There's so much that one doesn't know and this forum is a fantastic way of
improvement.

Thanks
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"David Biddulph" wrote:

Are you sure that you don't mean =A2A1 rather than =A2:C2A1:C1 ?
If you copy that across (or select the range A2:C2 before imposing the
CF),
then for C2 that will become =C2C1
--
David Biddulph


"Russell Dawson" wrote in
message
news
I'm using 2007 where c/f is much better than in previous editions but I
think
you should be able to handle this.
As I remember you have 2 options in 2003. Cell value (as per your
description) and formula value.
Set a formula that formats cells a2:c2 if their individual value is
greater
that a1:c1
=A2:C2A1:C1
That should get you started.
Apologies if that's not what you meant
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"Fred Holmes" wrote:

Excel 2000 (or a later version if necessary)

I know generally how to do conditional formatting, e.g., with the
compaison of the cell value with an explict (hard coded) number or
string. But how does one make the comparison between the value of the
current cell, and, e.g., the value of the cell immediately above it.
Any attempt I make to put a range address as the test value bombs.

Is there some element of code I'm missing, or does conditional
formatting not do it at all.

TIA.

Fred Holmes
.


.