| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Conditional Formatting down rows
New to Office 2007, but am very frustrated. When I copy a cell's formatting
(either by paste/special/formats or format painter) the conditional formatting is not using the relative cell row reference but instead always referring back to the original cell even though I am not using the absolute $ reference. For example: CF = A10100 (in cell A10) when I copy the format to B10 CF = A10100 If I copy the format to B10:F10 CF in all cells = B10100 What is going on?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Conditional Formatting down rows
It works ok for me. Here are the steps I used:
Select the range A10:F10 Goto Home tabStylesConditional FormattingManage RulesNew RuleUse a formula to determine which cells to format =A10100 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Whit" wrote in message ... New to Office 2007, but am very frustrated. When I copy a cell's formatting (either by paste/special/formats or format painter) the conditional formatting is not using the relative cell row reference but instead always referring back to the original cell even though I am not using the absolute $ reference. For example: CF = A10100 (in cell A10) when I copy the format to B10 CF = A10100 If I copy the format to B10:F10 CF in all cells = B10100 What is going on?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Conditional Formatting down rows
I'm trying to use the Format Painter or Copy Special/Format options to copy
CF like I have been able to do in prior versions. In my spreadsheet, it is not progressing the rows like it should in a CF formula like =AND(C120,D12<1) and acting like I have entered it as =AND(C$120,D$12<1). It worked for a while under some special conditions, but now no matter what I do it replicates the exact same formula without progressing the rows like it should. Is there some kind of option that I need to set, is this a bug, ??? "T. Valko" wrote: It works ok for me. Here are the steps I used: Select the range A10:F10 Goto Home tabStylesConditional FormattingManage RulesNew RuleUse a formula to determine which cells to format =A10100 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Whit" wrote in message ... New to Office 2007, but am very frustrated. When I copy a cell's formatting (either by paste/special/formats or format painter) the conditional formatting is not using the relative cell row reference but instead always referring back to the original cell even though I am not using the absolute $ reference. For example: CF = A10100 (in cell A10) when I copy the format to B10 CF = A10100 If I copy the format to B10:F10 CF in all cells = B10100 What is going on?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Conditional Formatting down rows
Using Copy then Paste SpecialFormats still works ok for me.
Tell me *exactly* what cells you're trying to format based on what condition. I've *never* used the format painter so I don't know how it works. -- Biff Microsoft Excel MVP "Whit" wrote in message ... I'm trying to use the Format Painter or Copy Special/Format options to copy CF like I have been able to do in prior versions. In my spreadsheet, it is not progressing the rows like it should in a CF formula like =AND(C120,D12<1) and acting like I have entered it as =AND(C$120,D$12<1). It worked for a while under some special conditions, but now no matter what I do it replicates the exact same formula without progressing the rows like it should. Is there some kind of option that I need to set, is this a bug, ??? "T. Valko" wrote: It works ok for me. Here are the steps I used: Select the range A10:F10 Goto Home tabStylesConditional FormattingManage RulesNew RuleUse a formula to determine which cells to format =A10100 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Whit" wrote in message ... New to Office 2007, but am very frustrated. When I copy a cell's formatting (either by paste/special/formats or format painter) the conditional formatting is not using the relative cell row reference but instead always referring back to the original cell even though I am not using the absolute $ reference. For example: CF = A10100 (in cell A10) when I copy the format to B10 CF = A10100 If I copy the format to B10:F10 CF in all cells = B10100 What is going on?? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Conditional Formatting down rows
I finally figured it out by trial and error. In Excel 2003, when you look at
the conditional formatting it always shows the relative position like on cell C4 the calc for a CF would show as =C40. In Excel 2007 if I copy CF using somthing like Format Painter down a column like from C3:C6, when you look at the CF for cell C5 it shows as =C30 (the "anchor apply to row range"). This was confusing me because it looked like it was still referencing the C3 value but after trying it out it is actually referencing the correct C5 value. Why MS made this change is beyond me. Thanks for responding "T. Valko" wrote: Using Copy then Paste SpecialFormats still works ok for me. Tell me *exactly* what cells you're trying to format based on what condition. I've *never* used the format painter so I don't know how it works. -- Biff Microsoft Excel MVP "Whit" wrote in message ... I'm trying to use the Format Painter or Copy Special/Format options to copy CF like I have been able to do in prior versions. In my spreadsheet, it is not progressing the rows like it should in a CF formula like =AND(C120,D12<1) and acting like I have entered it as =AND(C$120,D$12<1). It worked for a while under some special conditions, but now no matter what I do it replicates the exact same formula without progressing the rows like it should. Is there some kind of option that I need to set, is this a bug, ??? "T. Valko" wrote: It works ok for me. Here are the steps I used: Select the range A10:F10 Goto Home tabStylesConditional FormattingManage RulesNew RuleUse a formula to determine which cells to format =A10100 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Whit" wrote in message ... New to Office 2007, but am very frustrated. When I copy a cell's formatting (either by paste/special/formats or format painter) the conditional formatting is not using the relative cell row reference but instead always referring back to the original cell even though I am not using the absolute $ reference. For example: CF = A10100 (in cell A10) when I copy the format to B10 CF = A10100 If I copy the format to B10:F10 CF in all cells = B10100 What is going on?? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy Conditional Formatting down rows
Ok, glad you got it straightened out.
Why MS made this change is beyond me I'm in total agreement on that. The cf user interface in Excel 2007 is not very user friendly! -- Biff Microsoft Excel MVP "Whit" wrote in message ... I finally figured it out by trial and error. In Excel 2003, when you look at the conditional formatting it always shows the relative position like on cell C4 the calc for a CF would show as =C40. In Excel 2007 if I copy CF using somthing like Format Painter down a column like from C3:C6, when you look at the CF for cell C5 it shows as =C30 (the "anchor apply to row range"). This was confusing me because it looked like it was still referencing the C3 value but after trying it out it is actually referencing the correct C5 value. Why MS made this change is beyond me. Thanks for responding "T. Valko" wrote: Using Copy then Paste SpecialFormats still works ok for me. Tell me *exactly* what cells you're trying to format based on what condition. I've *never* used the format painter so I don't know how it works. -- Biff Microsoft Excel MVP "Whit" wrote in message ... I'm trying to use the Format Painter or Copy Special/Format options to copy CF like I have been able to do in prior versions. In my spreadsheet, it is not progressing the rows like it should in a CF formula like =AND(C120,D12<1) and acting like I have entered it as =AND(C$120,D$12<1). It worked for a while under some special conditions, but now no matter what I do it replicates the exact same formula without progressing the rows like it should. Is there some kind of option that I need to set, is this a bug, ??? "T. Valko" wrote: It works ok for me. Here are the steps I used: Select the range A10:F10 Goto Home tabStylesConditional FormattingManage RulesNew RuleUse a formula to determine which cells to format =A10100 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Whit" wrote in message ... New to Office 2007, but am very frustrated. When I copy a cell's formatting (either by paste/special/formats or format painter) the conditional formatting is not using the relative cell row reference but instead always referring back to the original cell even though I am not using the absolute $ reference. For example: CF = A10100 (in cell A10) when I copy the format to B10 CF = A10100 If I copy the format to B10:F10 CF in all cells = B10100 What is going on?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy conditional formatting only? | Excel Discussion (Misc queries) | |||
| copy conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting Copy down Rows | Excel Worksheet Functions | |||
| How to copy conditional formatting | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Linear Mode
