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 check - Guide
- Count if cell contains number - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Gta 5 data download for pc - Download - Action and adventure
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.