Highlight cells with Text that match data validation menu
Solved/Closed
Gamul1
Posts
2
Registration date
Thursday September 22, 2016
Status
Member
Last seen
September 22, 2016
-
Sep 22, 2016 at 09:50 AM
Gamul1 Posts 2 Registration date Thursday September 22, 2016 Status Member Last seen September 22, 2016 - Sep 22, 2016 at 10:04 AM
Gamul1 Posts 2 Registration date Thursday September 22, 2016 Status Member Last seen September 22, 2016 - Sep 22, 2016 at 10:04 AM
Related:
- Data validation if cell contains text
- Display two columns in data validation list but return only one - Guide
- Tmobile data usage text - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Mint mobile data not working ✓ - Network Forum
- If cell contains date then return value ✓ - Excel Forum
1 response
Gamul1
Posts
2
Registration date
Thursday September 22, 2016
Status
Member
Last seen
September 22, 2016
Sep 22, 2016 at 10:04 AM
Sep 22, 2016 at 10:04 AM
Never mind. I figured it out.
I created a conditional rule for "Format only cells that contain"
Format only cells with: "Specific Text; Containing; =$C$3 (note, my full data sheet actually has the cell in I3 so that's what I used, I just kept C3 as that was my example)
In the Applies to I set it to : = $E (in Reality, my data set was $D:$F)
This now works as expected.
I created a conditional rule for "Format only cells that contain"
Format only cells with: "Specific Text; Containing; =$C$3 (note, my full data sheet actually has the cell in I3 so that's what I used, I just kept C3 as that was my example)
In the Applies to I set it to : = $E (in Reality, my data set was $D:$F)
This now works as expected.