| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditionally formatted ranges
Is it possible to insert a row into a conditionally formatted range and have
the formatting of the range be copied to the row? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditionally formatted ranges
KimC,
If you insert the row in between the range of conditional formats, the conditional formats will be inserted as well. Test: A1:1 A2:1 A3:2 Conditional Format: Cell Value = 1, Bold Insert row between A2:A3 A1:1Bold A2:1Bold A3:1Bold (new row) A4:2 -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "KimC" wrote: Is it possible to insert a row into a conditionally formatted range and have the formatting of the range be copied to the row? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum referencing Conditionally Formatted Cells | Excel Worksheet Functions | |||
| Find cells that are conditionally formatted | Excel Discussion (Misc queries) | |||
| Conditionally Formatted Cells | Excel Discussion (Misc queries) | |||
| Totalling numbers that are Conditionally Formatted | Excel Discussion (Misc queries) | |||
| Report for Conditionally Formatted Cells | Excel Programming | |||
Linear Mode
