Cells are filled for no reason?

Question

Level 1

13 points

Cells are filled for no reason?

Can't understand why certain cells are filled with random colours. I've got conditional formatting for any number higher than 15,000 in a darker blue, but have random cells filled with light green, light blue and light pink. No fill is active so I'm a bit baffled why this is happening - please see screenshots. I have alternating row colour turned off. It can be fixed by individually filling that cell with a white background but I don't particularly want to go through 10,000 lines individually.

Does anyone have any ideas? Thanks!

Posted on Mar 14, 2025 11:08 AM

Reply

Answer 1

Badunit

Level 7

30,366 points

Mar 15, 2025 7:09 AM in response to myf0712

Did this spreadsheet begin in Excel? I ask because that color appears to be exactly one of the colors from Office 2007-2010. If so, you are probably stuck changing the backgrounds to white. Sometimes Numbers imports things from Excel into places we don't have controls for. A prime example used to be chart borders that would import and display properly but we couldn't get rid of them (later versions fixed this).

You should be able to set the background color of your entire spreadsheet at one time, or to blocks of cells that should be white when the highlighting rule does not apply.

Reply

Answer 2

Badunit

Level 7

30,366 points

Mar 14, 2025 11:50 PM in response to myf0712

The green cell does not appear to be the one selected. Can you post the formatting and highlighting rules when the green cell is selected?

Reply

Answer 3

myf0712 Author

Level 1

13 points

Mar 15, 2025 1:01 PM in response to Badunit

Yes, it did start in Excel about 8 years ago and I switched it over to Numbers maybe a year ago? Thanks for the insight, I would never have thought of it and got increasingly more annoyed with myself for not being able to fix!

Reply

Answer 4

myf0712 Author

Level 1

13 points

Mar 15, 2025 1:38 AM in response to Badunit

Sorry for confusion, it was just a screenshot showing the green cell. It’s definitely the one selected when screenshotting the highlighting rules.

Reply

Cells are filled for no reason?

Similar questions