Highlight cells with Text that match data validation menu
Solved/Closed
Gamul1
Posts
2
Registration date
Thursday 22 September 2016
Status
Member
Last seen
22 September 2016
-
22 Sep 2016 à 09:50
Gamul1 Posts 2 Registration date Thursday 22 September 2016 Status Member Last seen 22 September 2016 - 22 Sep 2016 à 10:04
Gamul1 Posts 2 Registration date Thursday 22 September 2016 Status Member Last seen 22 September 2016 - 22 Sep 2016 à 10:04
Related:
- Data validation if cell contains text
- Tmobile data check - Guide
- How to copy data from one excel sheet to another - Guide
- Mint mobile data not working ✓ - Network Forum
- Blancco data cleaner - Download - Cleaning and optimization
- Copying data from one Excel sheet to another. ✓ - Excel Forum
1 response
Gamul1
Posts
2
Registration date
Thursday 22 September 2016
Status
Member
Last seen
22 September 2016
22 Sep 2016 à 10:04
22 Sep 2016 à 10:04
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.