I'm trying to replicate a Excel report in RMarkdown. I have a lot already in place but I need help with conditional formatting
I have a GT (package) table that has 3 colour (White, Orange, Red) conditional formatting, but I need to tell the function to change colour at a certain number. In Excel the rule is setup like
- Minimum (White, value = 0),
- Midpoint(Orange, value = 50),
- Maximum(Red, 100)
Is it possible to pass the 0, 50, 100 value to the data_color() function somehow?