How to mark a cell in calc if it contains a defined string? [closed]

asked 2018-02-01 16:52:30 +0100

inJesus
83 ●24 ●36 ●40 http://j.mp/life-fb

If a cell in column A contains "FP" (case sensitive) it shall become blue font color (or otherwise highlighted). How to do this?

My goal is to easily see cells containing a special string (as part of the content) when scrolling.

(If this is not possible without a macro, I would be also interested how to fill out a correspondent cell with a string. Or any other workaround to fullfill the goal.)

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-28 15:05:40.153018

answered 2018-02-01 20:37:47 +0100

Jim K

4261 ●7 ●27 ●55

Select column A by clicking on the column header, and go to Format -> Conditional Formatting -> Condition.

Formula is FIND("FP";A1;1)
Apply Style Good

Then press OK.

conditional formatting

This answer was adapted from https://forum.openoffice.org/en/forum....

edit flag offensive delete link

Comments

Thank you so much. I praise God, this is helping in accounting for mercy projects. Blessings, Klaus

inJesus ( 2018-02-02 07:22:35 +0100 )edit

What if I want to put a numeric value in an adjacent cell instead of applying a style?

kete ( 2020-10-04 17:08:09 +0100 )edit

add a comment

How to mark a cell in calc if it contains a defined string? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-28 15:05:40.153018

1 Answer

Comments

Question Tools

Stats

Related questions

How to mark a cell in calc if it contains a defined string? [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2020-10-28 15:05:40.153018

1 Answer

Comments

Question Tools

Stats

Related questions

How to mark a cell in calc if it contains a defined string? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-28 15:05:40.153018