Solved

Conditional formatting

  • 27 February 2023
  • 3 replies
  • 288 views

Hello,

Can you please tell me how I can make a conditional formatting based on another column? Ex: I have column A & B and I want column A figures to change colors depending of it they are greater or lower than column B figures.

Also, how can I center figures in a table on Pigment, if that is possible. 

Thanks.

icon

Best answer by abhilashsawla 28 February 2023, 06:18

View original

3 replies

Userlevel 4
Badge +6

Hi @Jessica T 

Currently, we cannot do conditional formatting based on another column.

Userlevel 4
Badge +6

Hi @Jessica T 

You can create variance absolute for these two Column and then provide Conditional Formatting to Variance absolute column.

Conditional formatting is only allowed on numbers? Is it also possible to highligh a text or boolean field?

Reply