Support Board

Date/Time: Fri, 20 Sep 2024 04:01:38 +0000

Post From: Flagging up certain dates in a spreadsheet column

[2014-09-03 22:59:00] Link To Thread - Link To Post [Go To First Post]
swandro - Posts: 11
I want to flag up certain days. So I place an "X" in cell BB24, for example, in the same row as the date I want to flag. I then use column K to look for this "X" and if it is present, set the bar to a certain colour. I cannot get this to work. The reason is that when new data is added, the early columns are shifted down but column BB is not shifted down, so the "X" ends up against a different date. If I put this flag in one of the early columns such as column Y, it will be overwritten on updates, because the value in Y3 is copied down and overwrites the flags. So what I need is a column where rows can be added at the top but where the value / formula in the top row is not copied down. Is this achievable? Am I overlooking something obvious? Thank you.