Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and manipulate the data accordingly. Some knowledge of programming concepts ...

Excel's IF function ... Paid Using Excel How to Track the Money Owed & Paid Using Excel. Microsoft Excel allows you to enter both... How to Format a Row Based on the Value of a Cell in Excel ...