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.
Best answer by abhilashsawlaView original
Currently, we cannot do conditional formatting based on another column.
You can create variance absolute for these two Column and then provide Conditional Formatting to Variance absolute column.