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 December 27, 2022 - Mar 17, 2016 at 12:33 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 17, 2016 at 12:33 PM
Related:
- Highlight a range of cells if condition met
- Folder highlight - Download - Customization
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
- Apple airtag range - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Count if cell contains number - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
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
