-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Formulas for color fill and color text.
- Thread starter Eamonn100
- Start date
I have a column with different text. The cell I'm looking for has text saying "Most recent day: Monday, Tuesday, Wednesday, Thursday, Friday." How would I find this cell when the "Most recent day:" stays fixed but the days change. I have formulas for finding cells when all the text stays fixed but trying to find a cell when only part of the text stays the same I just can't get.
Upvote
0
I was using conditional format to fill green with any cell that contains "Most recent day:".
There is another cell with "Most recent day:". That cell is a little different as it has some text before "Most recent day" but after "Most recent day" both cells will have the same text.
There is another cell with "Most recent day:". That cell is a little different as it has some text before "Most recent day" but after "Most recent day" both cells will have the same text.
Upvote
0
Can I just say because the text after "Most recent day" is the same, if it's a case of choosing one cell or the other it would be ok.
Upvote
0
Scott T
Well-known Member
- Joined
- Dec 14, 2016
- Messages
- 2,636
- Office Version
- 365
- 2016
- Platform
- Windows
Try this is an array formula and must be entered with CONTROL+SHIFT+ENTER. If done correctly Excel will put {} around the formula. If there are ever multiple cells that start with "Most recent date:" then the formula will return the first one.
Where B2:B7 is the range you want to look for "Most recent day:"
Where B2:B7 is the range you want to look for "Most recent day:"
Code:
=INDEX(B2:B7,MATCH("Most recent day:",LEFT(B2:B7,16),0))
Upvote
0
Similar threads
- Solved
- Solved
