Skip to main content

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.

Hi @Jessica T 

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


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