Automatically colour filled cells

%3CLINGO-SUB%20id%3D%22lingo-sub-938557%22%20slang%3D%22en-US%22%3EAutomatically%20colour%20filled%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-938557%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20a%20problem.%20I%20want%20source%20of%20data%20that%20contains%20hours%20in%20cells%2C%20those%20cells%20are%20coloured%20filled%20manually%20when%20they%20they%20are%20paid.%20But%20what%20i%20hope%20to%20do%20is%20use%20that%20data%20to%20tell%20me%20when%20how%20much%20those%20hours%20represent%20in%20terms%20of%20%C2%A3.%20To%20do%20this%20I%20hope%20you%20use%20another%20tab%20pulling%20in%20the%20hours%20and%20multiple%20those%20hours%20by%20various%20hourly%20rates.%20I%20then%20have%20a%20colour%20function%20to%20tell%20me%20how%20much%20of%20these%20are%20unpaid%20for%20a%20specific%20period.%20But%20I%20cant%20figure%20out%20how%20to%20pull%20in%20the%20colour%20of%20the%20cell%20automatically%2C%20because%20it%20might%20changed%2C%20once%20they%20are%20paid.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-938557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-943267%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20colour%20filled%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-943267%22%20slang%3D%22en-US%22%3EColor%20is%20not%20seen%20by%20Excel%20as%20a%20value.%20It%20is%20better%20if%20you%20use%20an%20additional%20column%20in%20which%20you%20can%20have%20your%20users%20enter%20a%20%22Yes%22%20when%20an%20invoice%20has%20been%20paid.%20You%20can%20subsequently%20use%20SUMIF%20to%20sum%20the%20invoices%20which%20are%20paid%20(or%20the%20ones%20still%20outstanding)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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.

1 Reply
Highlighted
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)