Get instant live expert help on I need help with excel counting colored cells

I 'color fill' some cells on an excel spreadsheet. I want these colored cells to remain colored when I view the excel sheet on the screen, but I don't want these cells colored when I save the sheet as a PDF. Is this possible?

Have multiple sheets with colored cells (with no data contained within them) that I need to be all grouped together on a single sheet. Basically, if I have 3 cells colored on one sheet and 2 colored cells on another, I'd like a third sheet to show all 5 of the colored cells and automatically update as new cells become colored/uncolored.

I need help counting rows in Excel and placing them into cells.

I would like to have a total in a column of a number of cells that are colored only(and also have letters and numbers in them). For example in row AI of spread sheet attached, I would like the total of colored cells only and ignore other data not in the colored cells.

I need an operation that counts the number of non-colored cells amongst other cells formated to have a slight colored background. The formatting on these cells is such that they are not responsive to colorfunction formulas.