View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default conditional formatting consecutive cells

Yes. Copying conditional formatting should copy and adjust the same as
copying a formula.
Give it a try. You can set your conditional formatting in one cell and then
copy the cell. Use Paste Special and Paste Formats to apply to other cells.

Good luck,
Paul


"chris" wrote in message
...
I'm trying to apply conditional formatting to a range of cells. I want the
formatting to work the same as if I was copying formulas, where the
consecutive cells change. Is it possible to do the same with formatting?
=$D$14<10
=$D$15<10