If two cells equal, then - how to

Alaza · Newbie Joined: 20 Mar 2012 Posts: 2

Hi there.

I am currently designing a spreadsheet in Ooffice Calc, and I'm a quite new to it. Is it possible for me to design it so, that if two cells contain the same value, they are marked red (or some other action is taken)?

Thank you

Tore

mgroenescheij · Posted: Tue Mar 20, 2012 3:34 am Post subject:

Hi,

You can use Conditional Formatting.
Add a formula e.g. A1=A2 and create a new Style where you have the background red.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

Alaza · Newbie Joined: 20 Mar 2012 Posts: 2

Hi again.

Thank you, very much what I was looking for.

I got it to work, almost. Is it possible that it can affect both of the cells, and not just the one? Even if I mark two cells, go to "conditional formatting", set up the formatting, only the first cell is affected by the formatting.

Thank you

Tore

keme · Posted: Tue Mar 20, 2012 5:59 am Post subject:

The conditional formatting uses absolute/relative addressing, so if you set the formatting for a range and didn't "lock" coordinates (by prefixing $), the non working cell(s) are comparing the wrong data. Select the cells in question and open conditional format. There will be differences...