Find and color the text in rows and column

sachin483
2StarLounger
Posts: 101
Joined: 03 Feb 2018, 04:20

Find and color the text in rows and column

Post by sachin483 »

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.

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Find and color the text in rows and column

Post by HansV »

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

sachin483
2StarLounger
Posts: 101
Joined: 03 Feb 2018, 04:20

Re: Find and color the text in rows and column

Post by sachin483 »

thanks a lot

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Find and color the text in rows and column

Post by HansV »

What would you prefer now?
Best wishes,
Hans

sachin483
2StarLounger
Posts: 101
Joined: 03 Feb 2018, 04:20

Re: Find and color the text in rows and column

Post by sachin483 »

now i am doing manually