Home

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
bayhota
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)
Related Conversations
Linking Adjacent Rows
ashwinash112 in Excel on
1 Replies