#1
|
|||
|
|||
Tricky conditional formatting and sumif function
I have a table of invoices. If a new invoice is added and that customer already has X invoices within the last 90 days that are not recorded as "Paid" in the status column then I want the new invoice entry to be formatted with a red background. I also want to maintain a running total of the value of all invoices whose status is "Paid", "Pending" etc. I want to achieve this by using formulas and not vba if at all possible. The attached spreadsheet should fill in any gaps in my explanation. |
#2
|
|||
|
|||
Here you go!
Edit About totals: When you set any filter to data table, the totals are calculated for visible rows only (i.e. they work like subtotal)! |
#3
|
|||
|
|||
Thanks for your help
WOW that was quick I'm very grateful
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel function sumif help | ganesang | Excel | 8 | 09-05-2021 08:53 PM |
Conditional formatting | technofrank | Excel | 3 | 06-08-2015 03:15 AM |
Conditional Formatting | sdfrance | Excel | 3 | 01-06-2015 07:10 AM |
WEEKDAY Function with Conditional Formatting | meggenm | Excel | 1 | 08-09-2014 09:42 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |