View original (French)

Billing amount breakdown

Dan664 Posted messages 1 Registration date   Status Member Last intervention   -  
via55 Posted messages 14393 Registration date   Status Member Last intervention   -

Hello,

I would like to solve a problem with the color coding of amounts in a billing summary table.
Column A: Customer name and Invoice reference,
Column B: Invoice date,
Column C: Invoice amount.
Column D: From 1 to 30 days,
Column E: From 31 to 60 days,
Column F: From 61 to 90 days.
Here is the structure of my table and I would like:
If the invoice is paid on the day of billing,
the amount in column C should be bold and green.
If the invoice is paid within 30 days,
the amount in column C should be entered in column D, in BOLD and GREEN.
If the invoice is paid between the 31st and 60th day,
the amount in column C should be entered in column E, in BOLD and ORANGE.
If the invoice is paid between the 61st and 90th day,
the amount in column C should be entered in column F, in BOLD and RED.
Of course, the column changes should happen automatically.

Thank you all for the help you can offer me.
Regards,
Daniel.


3 answers

  1.
    brucine Posted messages 24845 Registration date   Status Member Last intervention   4 169
     

    Hello,

    Not very understandable.

    There is no checkbox column if the payment is in cash and more generally allowing to enter the date of this payment, on which the coloring is based?

    A change of column will not be automatic from one to another but will result from a condition on the payment date.

    0