| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
copying conditional formatting
I'm doing an analysis of extensive data, and have setup conditional
formatting to display the results. Is there a way to copy the conditional formatting to the entire range of data? I have it setup in one cell, but when I copy it to the other cells in the column (either using Paste Special or the Paintbrush), it references the original cell. Do I have to manually adjust each cell (approx 450) or is there a shortcut? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
| Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| copying conditional formatting to an entire column | Excel Discussion (Misc queries) | |||
| COPYING CONDITIONAL FORMATTING TO A COLUMN | Excel Worksheet Functions | |||
Threaded Mode
