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

Ask Your Question

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

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

inJesus gravatar image

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

edit retag flag offensive reopen merge delete

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

Sort by » oldest newest most voted

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

Jim K gravatar image

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 more


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

inJesus gravatar imageinJesus ( 2018-02-02 07:22:35 +0200 )edit

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

kete gravatar imagekete ( 2020-10-04 17:08:09 +0200 )edit

Question Tools

1 follower


Asked: 2018-02-01 16:52:30 +0200

Seen: 4,009 times

Last updated: Feb 01 '18