Hi,
I wonder if you could help me work something out -
I have a minute by minute schedule document built in Excel. There are a few activities which could take place, and I'm using conditional formatting to change cell colors based on the name of the activity.
What I haven't yet worked out is this:
When a cell is empty, that is because there is no change in activity - so I would like that cell to be the same colour as the last change of activity. I think the simplest way to do that would be for any empty cell to take the color of the cell above. That would mean that if an activity was entered in a cell, the color would change to the appropriate one, and if no activity was entered the color would be that of the one above, all the way back up to the last change.
I hope that makes some sort of sense - if anyone could point me in the right direction I would be very grateful.
Thanks in advance,
P
I wonder if you could help me work something out -
I have a minute by minute schedule document built in Excel. There are a few activities which could take place, and I'm using conditional formatting to change cell colors based on the name of the activity.
What I haven't yet worked out is this:
When a cell is empty, that is because there is no change in activity - so I would like that cell to be the same colour as the last change of activity. I think the simplest way to do that would be for any empty cell to take the color of the cell above. That would mean that if an activity was entered in a cell, the color would change to the appropriate one, and if no activity was entered the color would be that of the one above, all the way back up to the last change.
I hope that makes some sort of sense - if anyone could point me in the right direction I would be very grateful.
Thanks in advance,
P