Hello all,
could you help me on the formula CELL(color....

I would like :

if value in A2 is equal or above A1, I would like to have the cell A
and A2 in blue, otherwise, without color.

Regards

Herv

--
herv
-----------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...fo&userid=2731
View this thread: http://www.excelforum.com/showthread.php?threadid=49083

use
format
conditional formatting
for a1 if smaller or equal to a2
for a2 if greater or equal to a1
format
pattern

--
Greetings from New Zealand
Bill K
"herve" wrote in
message ...

Hello all,
could you help me on the formula CELL(color....

I would like :

if value in A2 is equal or above A1, I would like to have the cell A1
and A2 in blue, otherwise, without color.

Regards

Herve


--
herve
------------------------------------------------------------------------
herve's Profile:
http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=490839

You need conditional formatting, with a formula of =$A$2=$A$1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"herve" wrote in
message ...

Hello all,
could you help me on the formula CELL(color....

I would like :

if value in A2 is equal or above A1, I would like to have the cell A1
and A2 in blue, otherwise, without color.

Regards

Herve


--
herve
------------------------------------------------------------------------
herve's Profile:
http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=490839

Hi Herve,
Did you really mean to compare A1 and A2 or did you mean
to compare A1 and B1

In any case take a look at
http://www.mvps.org/dmcritchie/excel/condfmt.htm

if A1 and B1 then you probably want a formula like
=$B2=$A1 with the active cell any cell on row 1 though normally A1

if A1 and A2 then you probably want a formula like
=$A2=$A1 with active cell any cell on row 1 and you would
be formatting with color the last row in a group of equals.

If you want to band rows with the same values it gets more complicated:
and you would need a helper column;
http://www.mvps.org/dmcritchie/excel...t.htm#grouping

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"herve" wrote in message
...

Hello all,
could you help me on the formula CELL(color....

I would like :

if value in A2 is equal or above A1, I would like to have the cell A1
and A2 in blue, otherwise, without color.

Regards

Herve


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=490839