Reply With Quote
I have idea for count cell color. See attachmentOriginally Posted by msorange
Using "IF" statement to count number of highlighted or colored font cells
Hi,
Is this even possible?? Maybe I could append a unique identifier, one for the highlighted cells, and one for the colored font cells, then I could count the cells easier. I hate using color and highlighting in spreadsheets this way. The spreadsheet I am working with is very wide, about 430 columns, so I am trying to get rid of the cells I don't need to make the table work better for me. Any and all suggestions are greatly appreciated!
Kelly
I have idea for count cell color. See attachment
My personal Web Excel Tutorials
Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
Also for a decimal number I use a comma (,) you may need to use point (.) instead of
Assuming that coloured fonts are those apart from black, you could do a CF for this as well?
Bookmarks