| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying conditional formats (2007 Beta)
I need to copy my conditional Format to multiple cells. I am using the
"Format all cells based on their values," with the format style being the "Icon Sets." When I put in the rules, I am unable to take out the $, as it says "You cannot use relative references for Conditinal Formatting criteria." How do I copy without getting the value from the original cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
copying conditional formats (2007 Beta)
Try Selecting all the cells and then applying the CF, I've not tried xl2007
but that's how I allways do it. HTH "Bud" wrote: I need to copy my conditional Format to multiple cells. I am using the "Format all cells based on their values," with the format style being the "Icon Sets." When I put in the rules, I am unable to take out the $, as it says "You cannot use relative references for Conditinal Formatting criteria." How do I copy without getting the value from the original cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
| With the new file formats in Excel 2007 what are the worksheet dim | Excel Discussion (Misc queries) | |||
| Convert Text to Columns with Excel 2007 beta does not work well | Excel Worksheet Functions | |||
| Conditional Formats in Excel | Excel Worksheet Functions | |||
| copying conditional formats to a whole column | Excel Worksheet Functions | |||
Linear Mode
