=cell(color????

[herve]

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

 

[Bill Kuunders]

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

 

[Bob Phillips]

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

--

HTH

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

 

[David McRitchie]

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/condfmt.htm#grouping