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
- Excel merge cells if condition met ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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
