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
well, i am regular for excel. now i need a help,

if a cell value, is a particular text, then i want to display a range of cells at a particular location in the same sheet. can somebody help me out.

thanks

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
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
0