Hi!
I want to create a conditional formatting based on value of the same row but in a different column, i.e. if the Value at a cell from the 2nd row on column X is bigger than a value of a cell from the 2nd row on column Y - this cell should be green
See screenshot:
In this example, the top left cell should be red, as 19.6% is smaller than 27.8%
middle cell on the left should be green an also the bottom left cell
{{self.value < currentRow.columnY?'red':'green'}} added to background in column X {{self.value < currentRow.columnX?'red':'green'}} added to background in column Y
You can also use hex values instead of "red"/"green"
Remove value after self {{self < currentRow.columnY?'red':'green'}} added to background in column X {{self< currentRow.columnX?'red':'green'}} added to background in column Y