I have a problem. I want source of data that contains hours in cells, those cells are coloured filled manually when they they are paid. But what i hope to do is use that data to tell me when how much those hours represent in terms of £. To do this I hope you use another tab pulling in the hours and multiple those hours by various hourly rates. I then have a colour function to tell me how much of these are unpaid for a specific period. But I cant figure out how to pull in the colour of the cell automatically, because it might changed, once they are paid.
Color is not seen by Excel as a value. It is better if you use an additional column in which you can have your users enter a "Yes" when an invoice has been paid. You can subsequently use SUMIF to sum the invoices which are paid (or the ones still outstanding)