Search results

Thanks everyone for your input. What I gathered is that I cannot do what I wanted to do with the check boxes and there isn’t a way to tie the 2 sections together to make them relative to each other without a macro. So as an alternate, I used conditional formatting and text – so when a check...

I have 7 sections of check boxes. I’d like to have it where if any check box in section A is selected, check boxes in section B cannot be selected (and vice versa). The check boxes in the other sections are not affected by either and can still be selected no matter what. Many thanks for the help!

Sorry to make you repeat yourself, I don't know how check boxes work. Just did a quick study and it looks like I have to link the checkbox (using From Controls FYI) to a cell and that cell will read True if checked and False if not checked. So going back to my other post, I think I got it all...

Sorry, just trying to be as clear as I can be. After playing around with your formula I was able to make it work for me. Can't seem to get it to find the exact match, your formula seems to find "containing" vs "exact match" but I think it's best I work with multiple criteria instead of...

Thanks Narayan, I just put that in there in case that had anything to do with answering my questions. Since I don't plan to use it myself, I don't really care. But getting back to may main question, is there a way to link the content in a checked box to a cell or formula? This is in relation...

Thanks, looks like this formula may work for me: NOT(OR(ISERROR(FIND($A$1,$A4)),ISERROR(FIND($A$2,$A4)))). However I just needed to at $ before A4 to have the formatting affect the entire row, not just the single cell. Excellent!! It’s even flexible with however I want to format things...

Does it matter if it's Forms or Active X in relation to my question? Hope it doesn't especially since I can't access Design Mode, it's grayed out for me, even when I've selected the cell that has the check box in it. Thanks!

I have a worksheet where the creator is using the checkbox feature from the Developer toolbar, or so it looks like. Can’t tell if it’s the Form Controls, or ActiveX Controls. Either way, I’m trying to see if there is a way to capture whatever was checked in a cell so I can use the captured...

I am looking to highlight rows where a cell in the row contains a specific combination of words. Here’s an example A1=Yes A2=Yellow Row reads (from A4, B4, C4, etc.): Row 4: "Yes" text text Row 5: "Yes, Yellow" text text Row 6: "No, Yellow" text text Row 7: "Yes, Yellow" text text...

Sorry, but no Bobhc. We need to have the hyperlinks from the orginal data work in the pivot table. Since that doesn't seem to be an option, we are lookin at other ideas. Thanks again for trying.

Hi Bobhc, While I see that option in a regular table, it is not offered that readily in a "pivot" table. Thanks for trying.

Thanks Suresh, but it looks like the answer is no - hyperlinks do not work in pivot tables. If you meant to direct me to another part of the document, please be specific where.

Trying not to use macros, I want to see if there is a way to filter information in sections and not have empty rows showing between the sections. Each section, based on the criteria selected, can contain 1-20+ lines and it’s not a set number for each criteria. I’m experimenting with a couple...

I am working on a Pivot Table and need to keep the hyperlinks from the original data active and working. I found an answer on some site stating highlight the cells in question, to go to the PivotTable Toolbar, Properties, Format and select “Display as hyperlink” however there is no such...