conditional formatting for multiple lines using similar criteria?

[I Am Baltimore]

Presuming values in Column A and Column D, how could you conditionall
format all values in Column A equal to or greater than those in th
same row but in Column D?

Would there be any way to apply that to a range? So far I haven't ha
luck.

Thanks

 

[Guest]

Hi Baltimore,

on A2 create a conditional format and change to "the formula is"

use =a2>=d2

choose the format and click OK

copy a2 to the other rows on column A and paste special formats

hth
regards from Brazil
Marcelo

"I Am Baltimore" escreveu:

 

[Bob Phillips]

Select all cells in column A
Goto CF
Change Condition1 to Formula Is
input a formula of =$A1>-$D1
Format as required
OK

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"I Am Baltimore"