View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Thomas [PBD] Thomas [PBD] is offline
external usenet poster
 
Posts: 154
Default 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?