Help I'm getting Document bleeding ?

[tonywatsonhelp]

Hi Everyone,
Ok so I've never had this before and I can not work out why its happening?

I have a document with several sheets.

On one sheets called master I have conditinal formating to show hide some cells by changing there colour (I say hide but besicly back ground is white so if I don't want the cell to show its white if i do its blue)

Now the strangest this i'm getting what I would describle as screen bleeding.

So when i'm in a different sheet if a change something that effects the master sheet i get like a few lines that have change bleeding through like its not updating the screen?
screen updating is on any ideas why this might happen? or what i can do to stop it?

Thanks

Tony

 

[mole999]

first thing i would do is shut down and restart. i often have issue where there isn't enough screen memory and it is still shown

 

[tonywatsonhelp]

Hi Everyone, just to let you know I've worked it out, I had screen updating set to true after the sheet was selected, and switch them around and all is good now, no idea why! lol

 

[mole999]

very high colour graphics use a lot of memory, if i have the option i work in 64,000 colours, rather than 16 million