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?

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?