conditional formatting for multiple lines using similar criteria?

[I Am Baltimore]

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

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

Thanks.

[Marcelo]

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:

>
> Presuming values in Column A and Column D, how could you conditionally
> format all values in Column A equal to or greater than those in the
> same row but in Column D?
>
> Would there be any way to apply that to a range? So far I haven't had
> luck.
>
> Thanks.
>
>
> --
> I Am Baltimore
> ------------------------------------------------------------------------
> I Am Baltimore's Profile: http://www.excelforum.com/member.php...o&userid=37081
> View this thread: http://www.excelforum.com/showthread...hreadid=568093
>
>

[Marcelo]

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:

>
> Presuming values in Column A and Column D, how could you conditionally
> format all values in Column A equal to or greater than those in the
> same row but in Column D?
>
> Would there be any way to apply that to a range? So far I haven't had
> luck.
>
> Thanks.
>
>
> --
> I Am Baltimore
> ------------------------------------------------------------------------
> I Am Baltimore's Profile: http://www.excelforum.com/member.php...o&userid=37081
> View this thread: http://www.excelforum.com/showthread...hreadid=568093
>
>

[Marcelo]

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:

>
> Presuming values in Column A and Column D, how could you conditionally
> format all values in Column A equal to or greater than those in the
> same row but in Column D?
>
> Would there be any way to apply that to a range? So far I haven't had
> luck.
>
> Thanks.
>
>
> --
> I Am Baltimore
> ------------------------------------------------------------------------
> I Am Baltimore's Profile: http://www.excelforum.com/member.php...o&userid=37081
> View this thread: http://www.excelforum.com/showthread...hreadid=568093
>
>

[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"
<[email protected]> wrote in
message news:[email protected]...
>
> Presuming values in Column A and Column D, how could you conditionally
> format all values in Column A equal to or greater than those in the
> same row but in Column D?
>
> Would there be any way to apply that to a range? So far I haven't had
> luck.
>
> Thanks.
>
>
> --
> I Am Baltimore
> ------------------------------------------------------------------------
> I Am Baltimore's Profile:
http://www.excelforum.com/member.php...o&userid=37081
> View this thread: http://www.excelforum.com/showthread...hreadid=568093
>