Excel assistance required

[singist]

I thought that I'd ask you clever gents/ladies how to overcome a problem that has shown up recently in the small office (4 people) of the company I drive for:

They run a costomised spreadsheet for a courier business but for some reason, every tenth row has changed the inteior/background colour to almost the same as the text, making reading of the cells quite taxing.

Nobody seems to have any idea how to fix this so I thought that you kind people might earn me some brownie points by telling me how to go about changing the background colour to a different colour on those cells.

All assistance gratefully received.

 

[Makhaira]

Sounds like there might be a conditional format on those rows. Pick one of the cells in question, and go to Format > Conditional Formatting. Remove any rules in place and see if that sorts things!

 

[overclick]

Yeah, sounds like the rows are highlighted due to some form of formatting.

In the unlikely event someone has just changed the background colour on every 10th line (very unlikely!) then select the entire sheet (topleft button between A and 1) and set the fill colour to none.

Try Makhaira's 1st though as it does sound like a formating issue!

 

[singist]

Thanks for the input: I'll suggest the possible solution to them on Monday and see if I can earn a few brownie points (need 'em)

Thanks again!