| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting for multiple lines using similar criteria?
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting for multiple lines using similar criteria?
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" <I.Am.Baltimore.2bzcui_1154635522.1996@excelforu m-nospam.com wrote in message news:I.Am.Baltimore.2bzcui_1154635522.1996@excelfo rum-nospam.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Criteria for Conditional Formatting | Excel Worksheet Functions | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| enhanced conditional formatting | Excel Discussion (Misc queries) | |||
| Can I set more than three criteria for conditional formatting? | Excel Worksheet Functions | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Linear Mode
