Is there some logic as to why those cells are colored like that (think Conditional Formatting). If there is, then we can maybe use that same logic for the calc. If the colors were added manually, then you will probably need VBA, color is cosmetic, not data, and formulas work on data - they cannot "see" color