View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jasonr17 jasonr17 is offline
external usenet poster
 
Posts: 12
Default copy conditional formatting, paste format without conditions

Having created a set of cells w/ simple conditional formats ( x 5, cell fill
is green, x=0 cell is grey, etc.), I would like to copy this grid of cells,
and paste grid w/ same color pattern to another area in the work sheet.

IE, 2x2 grid, top two cells are green, bottom two cells are grey (have
numbers in them causing the coloring) I would like to copy this 2x2 grid,
paste somewhere else without the numbers, just the formats.

Doable?

Thanks