Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting - Before Page Break | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
How break column formatting to vary cell widths vertically? | Excel Worksheet Functions | |||
Page break formatting changes when sent via e-mail | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |