Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy conditional formatting range
I've looked at similar queries but none of the suggestions worked for my
situation. I am trying to copy a conditional format from several cells in one row to additional rows. It's based on a formula. Here's what I have in one row: Formula: =$A$48="x" The format selected is red fill and white bold font. the "applies to" selection is =$A48:$K48 What I want to do is copy this function to additional rows such that placing an "x" in the first cell of any particular row applies the conditional formatting to the rest of the row's cells. I've tried format painter, copy special, insert rows, etc. All of the above will copy the format but it's all tied back to the source cell and the conditional formatting does not work as intended by placing an "x" in the first cell of each row. I used to be able to do this with format painter back in Excel XP but doesn't seem to work this way in 2007. Any assistance anyone can offer for this is greatly appreciated. -- Steven Leuck Builders Electric, Inc. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy conditional formatting range
The formula should be
=$A48="x" and not =$A$48="x" If this post helps click Yes --------------- Jacob Skaria "Steven Leuck" wrote: I've looked at similar queries but none of the suggestions worked for my situation. I am trying to copy a conditional format from several cells in one row to additional rows. It's based on a formula. Here's what I have in one row: Formula: =$A$48="x" The format selected is red fill and white bold font. the "applies to" selection is =$A48:$K48 What I want to do is copy this function to additional rows such that placing an "x" in the first cell of any particular row applies the conditional formatting to the rest of the row's cells. I've tried format painter, copy special, insert rows, etc. All of the above will copy the format but it's all tied back to the source cell and the conditional formatting does not work as intended by placing an "x" in the first cell of each row. I used to be able to do this with format painter back in Excel XP but doesn't seem to work this way in 2007. Any assistance anyone can offer for this is greatly appreciated. -- Steven Leuck Builders Electric, Inc. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy conditional formatting range
Thank you thank you thank you.
Amazing that after trying so many things it would be such a small thing. I love these forums and the collective wisdom and assistance given here. -- Steven Leuck Builders Electric, Inc. "Jacob Skaria" wrote: The formula should be =$A48="x" and not =$A$48="x" If this post helps click Yes --------------- Jacob Skaria "Steven Leuck" wrote: I've looked at similar queries but none of the suggestions worked for my situation. I am trying to copy a conditional format from several cells in one row to additional rows. It's based on a formula. Here's what I have in one row: Formula: =$A$48="x" The format selected is red fill and white bold font. the "applies to" selection is =$A48:$K48 What I want to do is copy this function to additional rows such that placing an "x" in the first cell of any particular row applies the conditional formatting to the rest of the row's cells. I've tried format painter, copy special, insert rows, etc. All of the above will copy the format but it's all tied back to the source cell and the conditional formatting does not work as intended by placing an "x" in the first cell of each row. I used to be able to do this with format painter back in Excel XP but doesn't seem to work this way in 2007. Any assistance anyone can offer for this is greatly appreciated. -- Steven Leuck Builders Electric, Inc. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy conditional formatting range
Thanks for your feedback Steven. You are most welcome..
If this post helps click Yes --------------- Jacob Skaria "Steven Leuck" wrote: Thank you thank you thank you. Amazing that after trying so many things it would be such a small thing. I love these forums and the collective wisdom and assistance given here. -- Steven Leuck Builders Electric, Inc. "Jacob Skaria" wrote: The formula should be =$A48="x" and not =$A$48="x" If this post helps click Yes --------------- Jacob Skaria "Steven Leuck" wrote: I've looked at similar queries but none of the suggestions worked for my situation. I am trying to copy a conditional format from several cells in one row to additional rows. It's based on a formula. Here's what I have in one row: Formula: =$A$48="x" The format selected is red fill and white bold font. the "applies to" selection is =$A48:$K48 What I want to do is copy this function to additional rows such that placing an "x" in the first cell of any particular row applies the conditional formatting to the rest of the row's cells. I've tried format painter, copy special, insert rows, etc. All of the above will copy the format but it's all tied back to the source cell and the conditional formatting does not work as intended by placing an "x" in the first cell of each row. I used to be able to do this with format painter back in Excel XP but doesn't seem to work this way in 2007. Any assistance anyone can offer for this is greatly appreciated. -- Steven Leuck Builders Electric, Inc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy Conditional Formatting? | Excel Discussion (Misc queries) | |||
Can I copy conditional formatting? | New Users to Excel | |||
copy conditional formatting | New Users to Excel | |||
How to copy conditional formatting | Excel Worksheet Functions |