Display a range of cells if a condition (text) is met
Closed
BEKNAL
Posts
1
Registration date
Wednesday March 16, 2016
Status
Member
Last seen
March 16, 2016
-
Mar 16, 2016 at 12:16 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 17, 2016 at 12:33 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 17, 2016 at 12:33 PM
Related:
- Highlight a range of cells if condition met
- Excel if range of cells contains specific text ✓ - Excel Forum
- Highlight cell if another cell contains text ✓ - Excel Forum
- Excel copy data from one sheet to another if a condition is met - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Mar 17, 2016 at 12:33 PM
Mar 17, 2016 at 12:33 PM
Hi Beknal,
To hide/display a range of cells you can either:
- hide row/column using VBA.
- put IF statements in the range of cells referring to the particular text.
- using conditional formatting to change the textcolor to white to hide and back to black to show. Although the text can still be seen when selecting the range of cells.
Try it and let us know your thoughts.
Best regards,
Trowa
To hide/display a range of cells you can either:
- hide row/column using VBA.
- put IF statements in the range of cells referring to the particular text.
- using conditional formatting to change the textcolor to white to hide and back to black to show. Although the text can still be seen when selecting the range of cells.
Try it and let us know your thoughts.
Best regards,
Trowa
