Conditionally formatted ranges

K

KimC

Is it possible to insert a row into a conditionally formatted range and have
the formatting of the range be copied to the row?
 
T

Thomas [PBD]

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
 
Top