Hiding Sheets using conditional formating

**marzia.fatimah** · 08-07-2014, 04:09 PM

hi,

i have a list of services with "yes" or "no" options in the column beside it. Description for each service is given on separate sheets (Workbook sheet 1, Workbook sheet 2..etc). i want to format it in a way that if i choose "no" for one of the services, its description sheet hides.

**Paul** · 08-07-2014, 05:10 PM

You can't do this with Conditional Formatting, it would require a macro linked to the Worksheet_Change event for the sheet on which you're entering Y and N values.

**marzia.fatimah** · 08-07-2014, 05:26 PM

would you mind showing me the link to find some info about entering MACROs in worksheets?

**Paul** · 08-07-2014, 05:31 PM

Here's a few:

http://dmcritchie.mvps.org/excel/event.htm

http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

http://www.cpearson.com/excel/Events.aspx

You may still have questions after viewing these pages and trying on your own. If so, come on back and ask. It may also help to provide a copy of your workbook (after removing any sensitive data).