I have searched the forums and read the documentation and cannot find a solution to my particular scenario, which is as follows:
I have a table object which I want to use alternating row colors on, and this works fine.
Now, in the same table I also want to color certain rows which are “in alarm” based upon the value in a particular column (time column) by product category. So, I have another table which has categories for inventory and the maximum amount of time an item in each category can sit in inventory before I color the row red. This is different for each category, of course, so a fixed numeric value in a mapping table will not suffice since multiple products show up in the table.
So, in the final analysis, I want to have alternating row colors as I currently do, but also if the row category shows that it has been sitting in inventory longer than the allowable time from the other table (I could make this into an invisible column in the table if needed) then it should be red instead of the alternating color scheme. Is this possible to combine the two somehow, or access individual background color properties and script this function?