L
Legacy 170197
Guest
Hi,
I ran into a strange problem. I've used fill to colour a certain range of cell, but when I enter text or numbers in cells adjacent to the coloured cells (or even in cells not directly adjacent but a column apart from the coloured cells) those cells also change colour (aquiring the same colour as the filled cells). I haven't a clue what is causing this, but I did run into the same problem before when using conditional formatting (months apart and in different files altogether), so it seem as though not only the fill is mysteriously copied but the entire cell format.
Has anyone ever run into something similar? And did anyone ever find out how to solve this?
I'd be very grateful if someone helps me solve this annoying problem!
Cheers,
Philoe
I ran into a strange problem. I've used fill to colour a certain range of cell, but when I enter text or numbers in cells adjacent to the coloured cells (or even in cells not directly adjacent but a column apart from the coloured cells) those cells also change colour (aquiring the same colour as the filled cells). I haven't a clue what is causing this, but I did run into the same problem before when using conditional formatting (months apart and in different files altogether), so it seem as though not only the fill is mysteriously copied but the entire cell format.
Has anyone ever run into something similar? And did anyone ever find out how to solve this?
I'd be very grateful if someone helps me solve this annoying problem!
Cheers,
Philoe
