5 posts • Page 1 of 1
- Posts: 61
- Joined: 03 Feb 2018, 04:20
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.
- Posts: 69449
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
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.