Hi All,
I set up my spreadhseet so the "data entry" pages have nice conditional formatting giving new colors for each year. This was the start of my VBA quest...
2000
2000
2001
2001
Next I thought it would be a good idea to put a line between the different dates using:
The code worked exactly as advertised giving me:
2000
2000
Blank line - no color
2001
2001
BUT...the conditional formatting was absent on the rows which were inserted! So if I typed 2001 in the "Blank Line" it would not change the color as all the other 2001's and the actual condition rules changed to ignore the newly inserted line.
Does anyone have any thoughts on how I can correct this? I know I could write an entire macro to rearrange everything and make the right colors...But, that would be way overkill! If it is a simple(ish) fix I'd like to try, but this is the final cosmetic change to my spreadsheet, so it is not completely necessary.
Thank you!
Bookmarks