Find and color the text in rows and column
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Find and color the text in rows and column
I have around 5000 rows with 9 to 10 column i want to find the text from column A within the cell and color each with separate color and bold, cells can have formulas also
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78478
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Find and color the text in rows and column
It is not possible to color part of the result of a formula. So we either have to skip cells with formulas, or replace formulas with their results.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Re: Find and color the text in rows and column
thanks a lot
-
- Administrator
- Posts: 78478
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- 2StarLounger
- Posts: 101
- Joined: 03 Feb 2018, 04:20
Re: Find and color the text in rows and column
now i am doing manually