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.
Best answer by abhilashsawla
Hi
You can create variance absolute for these two Column and then provide Conditional Formatting to Variance absolute column.
+7Hi
Currently, we cannot do conditional formatting based on another column.
+7Hi
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?
+8Hi folks,
FYI we’ve done quite a bit of work on formatting this year - check out these articles:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
