View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Grey Newt Grey Newt is offline
external usenet poster
 
Posts: 16
Default onditional formatting

Most of your code can be got using the macro recorder.

Press F5, click Special, then select Conditional formatting. This will select all cells with conditional formatting.
You then need to walk through selected cells (for each cell in selection...) and lift out the properties that you want (there will be many !). Get these properties by recording yourself adding conditional formatting to a cell then disect the code.