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
...
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
.


.