Background colour dependabgt upon multicell values in Calc

English
#1

Hi

I have 2 columns and dependind on value in column 1 is bigger than value in column 2 I want to colour the background on column 2. Conditional formatting I just get to work depending on 1 column.

BR Christian

#2

Then you have to use/create a formula and can also combine conditions with AND() /OR() like

AND(A1 > 100; B1 <= 12)

In your case use A1>B1 and extend the range.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.