| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy formatting, Help
I have the following Conditional Formatting Formula (which works for the one Row); =D11=MAX($D$11,$F$11,$H$11,$J$11,$L$11,$N$11) Problem is I cannot copy this row down as needed. Excel always converts the Relative references to Absolute. I have used F4 to toggle to Relative but soon as I "Apply" they convert back to Absolute. What am I missing? Also, I'm using Office 2007. Bob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy a sheet's formatting from one xls to another? | Excel Discussion (Misc queries) | |||
| vlookup copy formatting | Excel Worksheet Functions | |||
| How do I copy formatting from one worksheet to several others? | Excel Discussion (Misc queries) | |||
| ... Can I Copy Conditional Formatting... | Excel Discussion (Misc queries) | |||
| How to copy conditional formatting | Excel Worksheet Functions | |||
Threaded Mode
