Why aren't all cell backgrounds the solid green color.

Hard to tell without the workbook so, if you can. please attach it, or at least that page.

I can tell you the original sent to me was an xlsx file and I used a converter to get it to xls. So the converter could have affected the background colors. It does say the converted file is in compatibility mode.

Last week's spreadsheet, same source, same converter, all desired cells were the same solid green.
I can't post the file because it contains the names of 32 people.

When I highlight the affected cells and change the color they are still not solid. It's the cells themselves it seems.

I can't post the file because it contains the names of 32 people.

Blank the names, attach the modified workbook or sheet, and undo the change or don't save the workbook.

I can not do that. I'm having to convert the file and the file has 3 pages as well as 3 more from last week as well as everyone's name elsewhere.
Here are two images where you see it is not row specific and not column specific either.
And in the cells that are not solid green there are two different shades.
 

All I need is one page (that you could copy to a new workbook) and delete the names on that page.

I copy pasted to a new excel sheet and then colored the background of certain cells and they all are the same color. But the lines that separate the rows and columns is very light and only with colors can I distinguish the lines.
One issue is the sender to me is using Office 2002 and I'm using 2007 and you are likely using a different one.

test-copy.xlsx

I copy pasted to a new excel sheet and then colored the background of certain cells...

I'm not sure I understand the process that results in the mis-colored cells. I assume it is something like
You import an xlsx file and convert it to an xls file. Why do you need to do that?
You then somehow paint certain cells green, How do you do that?
That results in some being the wrong shade of green. What happens if you copy that sheet(as opposed to copying the cells) to a new workbook?

1. The person who sends me the file sends a xlsx and my Windows Office won't open it. I have to use an online free converter to get it to xls.
2. I highlight the cells I want to be green and hold the control key down and highlight them and choose the background color of green. I've been doing for 17 weeks a year for over 8 years. It's never failed and did not fail last week on the same spread sheet.
3. Not sure how to copy a sheet.

3. Not sure how to copy a sheet.

1. Right-click on the tab of the sheet you want to copy
2. Select 'Move or Copy...' from the pop-up context menu
3. In the 'To book"' dropdown select '(new book)' or some other destination workbook that's already open
4. Check 'Create a copy'
5. Click 'OK'

Here tab 2 from the bottom saved to a new spreadsheet. Instead of most solid green and a few green with vertical strips it has added all the colors you see on the three pages, and the only ones that should be solid green are the teams that won their game in our office pool. On page 1 columns M through U if you look close you can see the off color cells that are supposed to be green. Where the pink came from not known. Those cells are supposed to have no background color. At the top of these sheets is: compatibility mode.
All of the non green you see on all pages are supposed to have no background color. All those yellow cells should not have a background color.
Book11111.xlsx

You said

The person who sends me the file sends a xlsx and my Windows Office won't open it. I have to use an online free converter to get it to xls.

If that is the case then how were you able to describe what is in Book11111.xlsx?

When they send to me I use a converter to convert it to xls. Then I opened it and copied a tab like you said.
The last file I posted shows the issue. All yellow cells that should have no background color and in the top page the ones that are an off color red are supposed to be green.

Because I did what you ask to be able to post the file.
I can not post the original because my system won't open it without an xls converter.

This started last year. The need to convert the file. I contacted the sender and they changed the way they sent it and after that no problems.
---------------
I don't know what version of Excel they are using and not sure about the other 30+ people. I can convert it each week but I will have these cell color issues onward. If we are the only ones unable to open it then they may not change formats just for us.

So assuming that all the others can open it, would it be because all 30 of them have a version of Excel newer than 2007 and the issue is that our version can not open an xlsx file?

Did you see the workbook and macro I posted?

Also, I don't know which file converter you are using but there are several free ones out there and you might see if one of them is better than the one you now use.

As long as all green cells are some shade of green, then which converter used is not critical.
Thanks.

I’m glad I was able to help.

If you expand the “Full Biography" section of my profile you’ll find links to some articles I’ve written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange Most Valuable Expert (MVE) 2015, 2017
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2018
              Experts Exchange Top Expert VBA 2018
              Experts Exchange Distinguished Expert in Excel 2018

thanks.

Pleased to help