Conditional printing from Excel

[Rik]

Is there a way to create a sheet with two columns, one a text string, the other a boolean value, and then use the boolean field to determine whether the text string prints?

Sue wants to create a shopping list in which she has her regular shopping, and then be able to tick off the stuff she wants, leaving the unwanted items unprinted. I can't work out a way to do it, not really using spreadsheets much and having cut my teeth on Quattro Pro anyway.

Thanks.

[Steve]

We used to do that but have now progressed to an A5 piece of paper and a Biro.

[Rik]

That's where I'm heading fast, Steve - though I prefer a roller-ball.

[zappaDPJ]

That's an interesting conundrum. The 'Hide' command under 'Cells' > 'Format' would probably stop the row being printed but that's messy. You could almost certainly write a macro to do it using an if/then/else loop or perhaps get my daughter to write a Visual Basic program to read the sheet and output the require list!

A macro would be the real answer. If you get stuck I might be able to knock one up.

[Rik]

Thanks, Zap. I'll have a dig around. This really should be so simple to implement.

[Steve]

http://exceltemplate.net/other/grocery-list/    maybe?

[Glenn]

That's no good, it's American, Rik needs a shopping list. 

[zappaDPJ]

Actually I think Conditional Formatting (under the Styles group) is possibly the way to do it (if Steve's suggestion doesn't work).

[Steve]

Mine's too complicated but the 'macros' maybe there?

[Rik]

Thanks, Steve, that may be the answer, provided I can modify it.

[Rik]

Actually I think Conditional Formatting (under the Styles group) is possibly the way to do it (if Steve's suggestion doesn't work).

Thanks, Zap, another route to consider.

[Simon]

For some reason, the things that seem as though they should be the simplest, are often the most difficult!

[pctech]

Story of my life 

[Technical Ben]

Do what I did, and give up. I just manually delete rows, then restore to the original file the next week.
That's what I've done for my customer database. I was going to use Open offices version of Access. But it just did not work the way I wanted it to (address fields, auto population of dates ect), and my programming/macro skills are zero. So I've done it all by hand.

[Rik]

I may just do that, though Steve's template looks possible.