Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy conditional formatting across column in the same row
I'm trying to copy a conditional format for a cell, into other cells across
the same row, but use data from a different column. What I have been able to achieve is... Column A Column B a1 b1 a2<a1=red b2<a1= red What I need it do to is: Column A Column B a1 b1 a2<a1=red b2<b1= red Any ideas would be greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy conditional formatting across column in the same row
Make sure the formula is using relative references.
=A2<A1 Note that there are no $ signs being used. -- Biff Microsoft Excel MVP "aspoto" wrote in message ... I'm trying to copy a conditional format for a cell, into other cells across the same row, but use data from a different column. What I have been able to achieve is... Column A Column B a1 b1 a2<a1=red b2<a1= red What I need it do to is: Column A Column B a1 b1 a2<a1=red b2<b1= red Any ideas would be greatly appreciated. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy conditional formatting across column in the same row
Do your conditional formatting on a2 only then simply copy and paste to cell b2
-- Val "aspoto" wrote: I'm trying to copy a conditional format for a cell, into other cells across the same row, but use data from a different column. What I have been able to achieve is... Column A Column B a1 b1 a2<a1=red b2<a1= red What I need it do to is: Column A Column B a1 b1 a2<a1=red b2<b1= red Any ideas would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Conditional Formatting? | Excel Discussion (Misc queries) | |||
Can I copy conditional formatting? | New Users to Excel | |||
Copy Conditional Formatting | Excel Discussion (Misc queries) | |||
copy conditional formatting | New Users to Excel | |||
How to copy conditional formatting | Excel Worksheet Functions |