Conditional formatting

[hyslopcw]

I have a list of competitions and would like to highlight finals. So would like to highlight any cell that contains final for example club final, pairs final.

In the attached example I would like any cell in column B that has the word final not including semi-final to be highlight in a colourtest.xlsx

[anon73440385]

Please clarify this question - it is incomprehensible, what conditions you want to apply to which cells. The simplest way is to use Conditional Formats based on the cell values using Format -> Conditional -> Condition (Hint: create your cell style in advance using Styles -> Manage Styles). Just one vague idea I got from the question is, that final might be THE keyword for your formatting. Please confirm, if that’s right …

[anon73440385]

Hello,

Please see attached file - I made a quite dumb Condition 1
Celle value is and Contains from dropdown and value " final" (incl. the quotation marks an watch the blank character)

ConditionalFormatXLSX.ods

Some hints

• I strongly recommend to use native .ods format for your file (just watch the questions here on ask.libreoffice.org for all the problems arising from default use of alien (related to LibreOffice) formats.
• The more complex your conditions are, the more complex the definition of an appropriate conditional format may be. You may also use formulas to define your conditions.
• Before you can use your own style, you need to create one, which fits your need (as already mentioned in my comment, use Styles -> Manage Styles. I have created one called BGGreen and used on the example

[schiavinatto]

@hyslopcw,

Follow solution

15676039186406346.xlsx

---

ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.

If the answer met your need, please click on the ball to the left of the answer, to finish the question.

[hyslopcw]

Many thanks