Is it possible to use conditional formatting in a table where the criteria will be if the value is => or < the value in the cell above it. In my example below, I am showing for each day the amount of technicians that are required in each area and how many were actually provided. I would like the cells in the "Actual" row to be green or red depending if the required number was met (green) or if the actual was less than the required number (red) for each of the areas.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Conditional formatting applies only to the values of a single column, and you cannot add a condition that uses a rule to reference another cell. So, you can add a rule that changes the color of a cell based on a specific value in that column. There's no way to match it against a different value from the same column or row.
Is it possible to use conditional formatting in a table where the criteria will be if the value is => or < the value in the cell above it. In my example below, I am showing for each day the amount of technicians that are required in each area and how many were actually provided. I would like the cells in the "Actual" row to be green or red depending if the required number was met (green) or if the actual was less than the required number (red) for each of the areas.
Hello Edward
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Conditional formatting applies only to the values of a single column, and you cannot add a condition that uses a rule to reference another cell. So, you can add a rule that changes the color of a cell based on a specific value in that column. There's no way to match it against a different value from the same column or row.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables