View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Conditional Format, copy down

Easier than you think.

Select the range you want the conditional format copied to but ensure the
range contains the cell whose format you want to copy. Click Format -
conditional formatting - OK and your done

"CLR" wrote:

Hi All.........
I have code which puts a 3-level Conditional Format in a cell, U9. I would
like to copy just that CF down the column U as far as there is data in column
C. I've tried, but just don't seem to be able to get it right, and recording
don't help.

TIA
Vaya con Dios,
Chuck, CABGx3