Ask Your Question
0

problems with conditional format

asked 2019-06-16 00:22:07 +0200

Ignacius241987Q@ert gravatar image

I've been learning the use of free office for a few days and it's a wonder, but I can not do the following ... I have a super simple spreadsheet at the moment, and I'm testing the conditional format, basically I want it to say, for example, HELLO in all the spreadsheet I put it in warning ....

I select the entire spreadsheet, then I go to format, conditional ... The value of the cell is: Contains and I put HELLO, in applying style I put for example warning ... I give it to add and accept ... but it does not happen nothing, you put in warning the red highlights ... but nothing, someone who can help me ???

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-06-16 06:25:35 +0200

Ratslinger gravatar image

updated 2019-06-16 06:28:29 +0200

Hello,

First insure Data - Calculate - AutoCalculate is enabled.

Then if you are comparing text, in the condition surround it with quotes - "HELLO"

This works on Ubuntu 18.04 using LO v6.2.0.3

edit flag offensive delete link more

Comments

Hello!!! Dear friend, following your instructions works 100%, I just miss the "" "thank you very much for your response, I will continue testing to migrate definitely, it is a great tool! My next step will be to open a spreadsheet of Microsoft Excel 2016 with calc ... we will see if it works well, any doubt I will be writing, a greeting

forgive me for my English, I am Spanish and my English level is basic, but I try to improve: d

Ignacius241987Q@ert gravatar imageIgnacius241987Q@ert ( 2019-06-16 14:41:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-06-16 00:22:07 +0200

Seen: 29 times

Last updated: Jun 16