View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default conditional formatting - break on Chg in Seq (Col A)

In Range A1:A10 I have the values:
1
2
3
4
1 << break in seq (is less or the same as previous row)
2
3
1 << break in seq (is less or the same as previous row)
1 << break in seq (is less or the same as previous row)
2

Columns B:L down to Row 10 have various other data

I would like a Macro that will perform conditional Formatting
in a toggle-fashion (green/blue) breaking on a sequence change in Col A;
Note Rows 1:4 = Green Rows 5:7 = Blue Row 8 = Green Rows 9:10 = Blue

Can someone suggest a start?