Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cONDITIONAL fORMATTING
I hope that this is the correct Forum for this question.....
I have downloaded MS excel 2007 beta. I have opened a spreadsheet from MS excel 2003. I have three conditional formats already set up. I would now like to copy the exisiting formating to make additional conditional formats however using differnt variables. I have tried COPY but this just copies the formulas etc into another cell. Would somebody have any ideas on how to do this please. I think that I would need approximately need another 5-6 conditional formats. Thank you Xerxers |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cONDITIONAL fORMATTING
Know nothing about Excel 2007, but in older versions, you use the Paintbrush
icon - format painter - to copy conditional formats "Xerxers" wrote: I hope that this is the correct Forum for this question..... I have downloaded MS excel 2007 beta. I have opened a spreadsheet from MS excel 2003. I have three conditional formats already set up. I would now like to copy the exisiting formating to make additional conditional formats however using differnt variables. I have tried COPY but this just copies the formulas etc into another cell. Would somebody have any ideas on how to do this please. I think that I would need approximately need another 5-6 conditional formats. Thank you Xerxers |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cONDITIONAL fORMATTING
Kassie,
Thank you for your response. I am not looking to copy the actual formatting but how to copy the Conditional Formats themselves i.e. the actual formulas. Xerxers "kassie" wrote: Know nothing about Excel 2007, but in older versions, you use the Paintbrush icon - format painter - to copy conditional formats "Xerxers" wrote: I hope that this is the correct Forum for this question..... I have downloaded MS excel 2007 beta. I have opened a spreadsheet from MS excel 2003. I have three conditional formats already set up. I would now like to copy the exisiting formating to make additional conditional formats however using differnt variables. I have tried COPY but this just copies the formulas etc into another cell. Would somebody have any ideas on how to do this please. I think that I would need approximately need another 5-6 conditional formats. Thank you Xerxers |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cONDITIONAL fORMATTING
That is how it works, if you copy the formats you will copy the conditional
formatting formulas as well -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "It is a good thing to follow the first law of holes; if you are in one stop digging." Lord Healey "Xerxers" wrote in message ... Kassie, Thank you for your response. I am not looking to copy the actual formatting but how to copy the Conditional Formats themselves i.e. the actual formulas. Xerxers "kassie" wrote: Know nothing about Excel 2007, but in older versions, you use the Paintbrush icon - format painter - to copy conditional formats "Xerxers" wrote: I hope that this is the correct Forum for this question..... I have downloaded MS excel 2007 beta. I have opened a spreadsheet from MS excel 2003. I have three conditional formats already set up. I would now like to copy the exisiting formating to make additional conditional formats however using differnt variables. I have tried COPY but this just copies the formulas etc into another cell. Would somebody have any ideas on how to do this please. I think that I would need approximately need another 5-6 conditional formats. Thank you Xerxers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |