how do you search for a value in one or more cells

I want to find rows that have a certain value or color!

Play with filters.

Values, yes; colors, uhmmm.

Please, see LibreOffice Help on Find & Replace. Hint: Current selection only.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer markCorrect answer mark) to the left of the answer that solves your question.