Conditional formatting on a row level

Queries and Resources
#1

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
image

Thanks!

#2

{{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"

#3

Thanks @ScottR, but it didn't help, it still colors it based on some other condition, as it is wrong :slight_smile:
image

#4

Without any more information it's difficult for me to understand what other conditions are impacting the cell...can you share more information?

#5

basically, if a cell from the left column is smaller than a correspondent cell in the right column I want it to be red, otherwise - green

#6

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

1 Like
#7

That helped, thanks!