View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default conditional formatting for multiple lines using similar criteria?

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