Display a range of cells if a condition (text) is met
Closed
BEKNAL
Posts
1
Registration date
Wednesday 16 March 2016
Status
Member
Last seen
16 March 2016
-
16 Mar 2016 à 12:16
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 17 Mar 2016 à 12:33
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 17 Mar 2016 à 12:33
Related:
- Highlight a range of cells if condition met
- How to increase wifi range - Guide
- Excel vba range find - Guide
- Excel copy row if condition met ✓ - Excel Forum
- "Cells(1, "a")" "type mismatch" ✓ - Excel Forum
- How to delete cells in word - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
17 Mar 2016 à 12:33
17 Mar 2016 à 12:33
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
