Conditional Formatting not working in all cells

[CatieBeth]

I set up conditional formatting to color code each year.  Not all cells are filling in with the background color.

[themistoklis · Accepted solution]

@CatieBeth 

Can you change the Summarization from Sum to Average or Mac and see what it returns?

[themistoklis · Accepted solution]

@CatieBeth 

Can you change the Summarization from Sum to Average or Mac and see what it returns?

[CatieBeth · Accepted solution]

Changing to Average seemed to fix it

Thank you