Conditional formatting : compare value of cell column A with value cell column B

[Celline]

Hi,

I am struggling to achieve something that is probably simple. Quite new to Calc!

I wish to compare column B cell (ex : B1) with column A cell (ex: A1) and if different apply a specific color to cell in B column.

Thanks a lot for your help!

[anon73440385]

Hello,

use (Format -> Conditional -> Condition)

1. Condition 1: Formula is IF(B1<>A1)
2. Apply Style: Select one or define a new one using New Style... from the drop down and make the settings fitting your needs
3. Cell Range B1:B30 (of course you need to adapt or use B:B

Tested using LibreOffice:

Version: 6.4.0.3, Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 8; OS: Linux 4.12; UI render: default; VCL: kf5; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US, Calc: threaded

Hope that helps.

If the answer helped to solve your problem, please click the check mark () next to the answer.