# Row of table automatically changes color after the due date has passed **URL:** \ **Category:** Ask for Help\ **Created:** [February 6, 2025, 12:14pm UTC](https://community.glideapps.com/t/row-of-table-automatically-changes-color-after-the-due-date-has-passed/79837 "2025-02-06T12:14:00Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Juli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juli/32/84841_2.png) [@Juli](https://community.glideapps.com/u/Juli)\ **Post date:** [February 6, 2025, 12:14pm UTC](https://community.glideapps.com/t/row-of-table-automatically-changes-color-after-the-due-date-has-passed/79837/1 "2025-02-06T12:14:00Z")
Not a native speaker so my english is going to be difficult to understand. Sorry in advance. So i am working on a project of interest, where it has a lot of dates, i want the color of the date changes when the due date passes. For example today is 6/2/2025, and today passed 5/2/2025, so the row of 5/2/2025 changes to color red. It would also be great if it could deduct the final value of the money after the interest ends. For example the interest suppose to end in 7/2/2025, and when 7/2/2025 comes, the amount of interest in the bank deduct from 100000 to 60000, reducing the money of the interest that is finished, and the remaining 40000 is of another interest plan. For example: Total amount in 6/2/2025:X+Y+Z -\>(after the interest plan ends and i claimed my money in 7/2/2025) → Total amount = X+Y, where Z was taken out on 7/2/2025 I would appreciate any help given. Thank you in advance ❤ ---
**Author:** ![Mariusz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariusz/32/89415_2.png) [@Mariusz](https://community.glideapps.com/u/Mariusz)\ **Post date:** [February 6, 2025, 2:29pm UTC](https://community.glideapps.com/t/row-of-table-automatically-changes-color-after-the-due-date-has-passed/79837/2 "2025-02-06T14:29:48Z")
Sure, all this will take is to have a math column and conditional visibility depending on what type of component you have. If you share how your component looks, it’ll be easier to assist you. ---
**Author:** ![Juli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juli/32/84841_2.png) [@Juli](https://community.glideapps.com/u/Juli)\ **Post date:** [February 6, 2025, 3:16pm UTC](https://community.glideapps.com/t/row-of-table-automatically-changes-color-after-the-due-date-has-passed/79837/3 "2025-02-06T15:16:45Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/5770f3372539a4e54ad1535736048ab8c1943ad8.png) something looks like this ---
**Author:** ![Mariusz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mariusz/32/89415_2.png) [@Mariusz](https://community.glideapps.com/u/Mariusz)\ **Post date:** [February 6, 2025, 5:17pm UTC](https://community.glideapps.com/t/row-of-table-automatically-changes-color-after-the-due-date-has-passed/79837/4 "2025-02-06T17:17:48Z")
I meant the interface 🙂 ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 7, 2025, 12:54am UTC](https://community.glideapps.com/t/row-of-table-automatically-changes-color-after-the-due-date-has-passed/79837/5 "2025-02-07T00:54:59Z")
> [@Juli](#): > > So i am working on a project of interest, where it has a lot of dates, i want the color of the date changes when the due date passes. For example today is 6/2/2025, and today passed 5/2/2025, so the row of 5/2/2025 changes to color red. So the “color” is something on the front end right? Can it just be a circle to denote the “status” of that row? > [@Juli](#): > > It would also be great if it could deduct the final value of the money after the interest ends. For example the interest suppose to end in 7/2/2025, and when 7/2/2025 comes, the amount of interest in the bank deduct from 100000 to 60000, reducing the money of the interest that is finished, and the remaining 40000 is of another interest plan. > For example: Is the “final value” a column in that same table? ---
**Author:** ![Juli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juli/32/84841_2.png) [@Juli](https://community.glideapps.com/u/Juli)\ **Post date:** [February 7, 2025, 12:42pm UTC](https://community.glideapps.com/t/row-of-table-automatically-changes-color-after-the-due-date-has-passed/79837/6 "2025-02-07T12:42:20Z")
the color if possible i would hope to highlight the whole row. it would not be effective if it is a circle since my client would like to know which of the interest ended so he/she can withdraw the money for another investment. Highlighting the whole row would be more systematic and have better understanding. The final value is a column in the same table ---
**Author:** ![Juli](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juli/32/84841_2.png) [@Juli](https://community.glideapps.com/u/Juli)\ **Post date:** [February 7, 2025, 12:42pm UTC](https://community.glideapps.com/t/row-of-table-automatically-changes-color-after-the-due-date-has-passed/79837/7 "2025-02-07T12:42:51Z")
the interface is just a table like this. nothing more ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [February 7, 2025, 12:49pm UTC](https://community.glideapps.com/t/row-of-table-automatically-changes-color-after-the-due-date-has-passed/79837/8 "2025-02-07T12:49:34Z")
> [@Juli](#): > > the color if possible i would hope to highlight the whole row. Does your plan support custom css? > [@Colored Items in Table? Custom CSS/ new Feature](https://community.glideapps.com/t/colored-items-in-table-custom-css-new-feature/79826/2): > > You can use the “Tag” column type instead of custom CSS. Use an if-else column to determine the color based on your desired conditions.