7/30 Lucian AMPS 99,+3.5/117,+9.5/160,PMPS 310

[nckitties3]

For some reason, his SS doesn't want to add the color to the numbers, I have to do it manually. Anyone else having an issue with it?

I'm btb, was up too late last night. ohmygod_smile

 

[BJM]

Re: 7/30 Lucian AMPS 99

There is a paint roller brush where you can click on a cell whose format you want to copy, click on the roller, then click on the cell which needs the format.

Or, if you'd like to know, here's how to Conditionally Format a Cell

 

[nckitties3]

Re: 7/30 Lucian AMPS 99,+3.5/117

That's still doing it manually. It used to do it automatically, unless you add something additional, then you had to do it. Now I have to add the color every time.

This started the other day, after I refreshed it, because it wouldn't work at all.

I'll check out the link and see if I can figure it out.

Edit - I checked out the format and mine has NO formatting rules at all, as though they have been deleted.

I added all new rules, saved them and they still don't work. Oh well, no biggie, just inconvenient.

 

[nckitties3]

Looks like a bit of a bounce. I can live with it.

 

[MommaOfMuse]

To fix the problem with the SS not adding color I'm going to guess that you have added lines to the spreadsheet, when you do that you have to add the formatting to the new lines. Lets see if I remember how to do that, first you highlight the new lines, then go to conditional formatting and mark the values you want like all numbers between 100-199 blue with white text. Yeah I know clear as mud, I'm sure but I'm sure you will figure it out.

Mel, Maxwell, Autumn & The Fur Gang

 

[nckitties3]

Ahhhhhhhhhh I didn't highlight the new lines. I did add new ones, cause I ran out of lines. I did add the conditional formatting but it didn't help. I'll work on that later. :lol: