Thread: Excel, how to copy conditional formats in sequential order 1,2,3
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ShoDan ShoDan is offline
external usenet poster
  
Posts: 13
Default Excel, how to copy conditional formats in sequential order 1,2,3
here is the formula I am using =NOT($Z$5=")

how do I copy or drag the formula down and have it change to

=NOT($Z$6=") then copy or drag it to change in the rows following each other
to
=NOT($Z$7=")
=NOT($Z$8=") and so on
Reply With QuoteReply With Quote