? Spreadsheet

[apple]

How do you remove the conditional formatting? Specifically, I'm looking to get rid if the neon green. It's extremely painful to look at the screen full if green.

I've been able to override fonts, cell size, color in units cells, but not neon green in +1, +2, +3 etc.

Thanks

 

[Tracey&Jones (GA)]

Did you want to change the colour for everything or just a few cells?

 

[Tracey&Jones (GA)]

If you go to format, there is a section for conditional formatting. If you click on that your should see all the conditional formats and the colour selection if the condition is met.

 

[apple]

Did you want to change the colour for everything or just a few cells?

I want to get rid of the neon green. All unfilled +time cells are terribly hard on my eyes.

 

[apple]

If you go to format, there is a section for conditional formatting. If you click on that your should see all the conditional formats and the colour selection if the condition is met.

I can't override the neon green.

 

[Tracey&Jones (GA)]

I just tried too and couldn't. Maybe @Yong knows? Seems like a tech guru.

 

[apple]

I just tried too and couldn't. Maybe @Yong knows? Seems like a tech guru.

I changed the rule to white and red, so I'll see what my eyes and body think of that.

 

[Tracey&Jones (GA)]

Good luck!

 

[Squeaky and KT (GA)]

You can make it another color by changing the conditional formatting. In each cell there's a hidden formula that says 'if number is over xxx, make cell red', if number is xxx-xxx, make cell blue, if number is xxx-xxx, make cell yellow...etc. The offending one says if number is 50 or below, change it to 'Color # (neon green)'. To fix this, you need to change that color # on the 50 and under condition. You can change this in one cell, exit - go back to that changed cell and COPY. Highlight all the rest of the cells where numbers are to be entered...then RIGHT CLICK. Choose 'Paste Special'...another menu comes up. On that menu, select 'Paste Format Only'. I THINK the action button says 'OK' but it may say something like 'apply'...can't remember that one.

I'll be glad to fix it for you if you'd like...just pm me, you'll need to give me permission to access your ssheet first then remove me when it's fixed.