Hey all! As the title says, I'm having trouble changing the color of an interactive grid's text field based on the value of another field, Im working on APEX 20.2 and I've made a CASE WHEN field that calculates the required condition and sets a value of ‘RED’ or ‘BLACK’ depending on if the color should be set to red or not, this is the method that has worked for me on interactive reports, however, I am not finding a way to do it in interactive grids since I cannot set the column formatting field. Also changing the field type to HTML expression is not an option since the field carries a date and I need to filter with it. I've tried using this field in javascript dynamic actions and on page level variable and function definition however neither has worked.
If someone has accomplished changing the color of a field dynamically based on the value of another field, item, or anything else inside an interactive grid please let me know any info would be super helpful
Thank you in advance!
Matias.