Ask Your Question

Conditional formatting

asked 2019-09-04 10:43:01 +0100

hyslopcw gravatar image

updated 2020-09-21 23:21:07 +0100

Alex Kemp gravatar image

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 colourC:\fakepath\test.xlsx

edit retag flag offensive close merge delete



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 ...

Opaque gravatar imageOpaque ( 2019-09-04 15:04:50 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-09-04 16:40:09 +0100

Opaque gravatar image

updated 2019-09-04 17:14:54 +0100


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)


Some hints

  • I strongly recommend to use native .ods format for your file (just watch the questions here on 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
edit flag offensive delete link more

answered 2019-09-04 16:40:20 +0100


Follow solution



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 Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more


Many thanks

hyslopcw gravatar imagehyslopcw ( 2019-09-05 15:36:11 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-04 10:43:01 +0100

Seen: 125 times

Last updated: Sep 04 '19