Ask Your Question

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

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 close merge delete

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 2,889 times

Last updated: Feb 01 '18