[SOLVED] Â Table - Conditional Formating |
12/13/2017 2:15:27 PM |
ASPRunner.NET General questions | |
I
i.NoLim author
Hello, if (data["TOTAL"]<150)
|
|
I
|
i.NoLim author 12/28/2017 |
Hello, I'm back, again.... I'm trying to change the background of a row or cell depending on the "TOTAL" amount. Background: I have 3 tables: Team, Member, and Charges. Family is linked to Member and Member is linked to Charges. The purpose of the app is for the end user to add a Team name, enter the Members information, and finally any Charges attached to each member. All charges for each team are then total, if the total exceeds 200 the row's, or cell's, background should change color. Example. Team A - Total = 100 -Mem1 - MemTotal = 35 -10 -25 -Mem2 - MemTotal = 15 -15 -Mem3 - MemTotal = 50 -30 -20 Team B - Total = 190 -Mem1 - MemTotal = 80 -40 -25 -15 -Mem2 - MemTotal = 45 -15 -30 -Mem3 - MemTotal = 65 -30 -20 -15 Above is what should happen but instead this is happening. Team B - Total = 190 -40 -25 -15 [color="#008080"] -Mem2 - MemTotal = 45 -15 -30 -Mem3 - MemTotal = 65 -30 -20 -15 I'm using the code in the tutorial. if (data["TOTAL"]<150)
|