We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

How do I make this cell (lets say green) if these cells have the same word.

asked 2018-08-24 16:57:37 +0200

pagg gravatar image

updated 2018-08-24 18:38:44 +0200

Hello, im pretty new with Libreoffice Calc, so i'd like some help
the problem I'm having is that I would like to do the following
If these two cells has this word, make this cell this colour.
for an example
A1 has the word aaa, and B1 also has aaa. I want to make C1 this colour (green).
But if A1 has the word aaa and B1 has bbb, I want to make C1 this colour (yellow).
And if A1 has the word bbb and B1 has bbb, I want to make C1 this colour (red)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-08-24 23:47:02 +0200

JBF gravatar image

Define a cell style for each colour you want use, then you can do what you want using conditional formatting applied on C1. The condition must be a formula.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-08-24 16:57:37 +0200

Seen: 42 times

Last updated: Aug 24 '18