Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007, Conditional Formatting, Format Painter
Hi! I had a question using the format painter in the new Excel 2007 for
conditional formatting. In my "old" version of Excel, if I had a conditional format in cell F5, I could format paint that conditional formatting from F6 through F200, and the relative reference that I used in F5 would update in F6, F7, F8, etc. Now, however, when I do that same function, all of the conditional formatting for F6 through F200 uses the relative reference of F6. The only way I've found to do this is to double-click the format painter, and individually click F6, and then F7, and then F8, etc. I'm pretty good at clicking, but this is too much - even for me! please help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007, Conditional Formatting, Format Painter
Hi
Rather than using the format painter, it is easier (IMO) in XL2007 to got to Conditional Formattingand change the range in the Applies to field -- Regards Roger Govier "cdankanis" wrote in message ... Hi! I had a question using the format painter in the new Excel 2007 for conditional formatting. In my "old" version of Excel, if I had a conditional format in cell F5, I could format paint that conditional formatting from F6 through F200, and the relative reference that I used in F5 would update in F6, F7, F8, etc. Now, however, when I do that same function, all of the conditional formatting for F6 through F200 uses the relative reference of F6. The only way I've found to do this is to double-click the format painter, and individually click F6, and then F7, and then F8, etc. I'm pretty good at clicking, but this is too much - even for me! please help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007, Conditional Formatting, Format Painter
Thanks for your reply! Maybe I wasn't clear enough. I need to have F5 be
conditionally formatted based on C5, and F6 on C6. Now I see that I wasn't clear enough at all. I'm sorry! "Roger Govier" wrote: Hi Rather than using the format painter, it is easier (IMO) in XL2007 to got to Conditional Formattingand change the range in the Applies to field -- Regards Roger Govier "cdankanis" wrote in message ... Hi! I had a question using the format painter in the new Excel 2007 for conditional formatting. In my "old" version of Excel, if I had a conditional format in cell F5, I could format paint that conditional formatting from F6 through F200, and the relative reference that I used in F5 would update in F6, F7, F8, etc. Now, however, when I do that same function, all of the conditional formatting for F6 through F200 uses the relative reference of F6. The only way I've found to do this is to double-click the format painter, and individually click F6, and then F7, and then F8, etc. I'm pretty good at clicking, but this is too much - even for me! please help? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007, Conditional Formatting, Format Painter
Hi
That's exactly what I am saying. Set the condition you want for any cell, then extend the range to apply to further cells in column F. Or, mark the range you want CF to apply to first, then set the CF based upon the first cell in the range, as a relative value, not an absolute. -- Regards Roger Govier "cdankanis" wrote in message ... Thanks for your reply! Maybe I wasn't clear enough. I need to have F5 be conditionally formatted based on C5, and F6 on C6. Now I see that I wasn't clear enough at all. I'm sorry! "Roger Govier" wrote: Hi Rather than using the format painter, it is easier (IMO) in XL2007 to got to Conditional Formattingand change the range in the Applies to field -- Regards Roger Govier "cdankanis" wrote in message ... Hi! I had a question using the format painter in the new Excel 2007 for conditional formatting. In my "old" version of Excel, if I had a conditional format in cell F5, I could format paint that conditional formatting from F6 through F200, and the relative reference that I used in F5 would update in F6, F7, F8, etc. Now, however, when I do that same function, all of the conditional formatting for F6 through F200 uses the relative reference of F6. The only way I've found to do this is to double-click the format painter, and individually click F6, and then F7, and then F8, etc. I'm pretty good at clicking, but this is too much - even for me! please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel 2007 | Excel Worksheet Functions | |||
Conditional formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel should allow you to use the format painter on a graph | Charts and Charting in Excel |