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?
|