Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
Jets Fan
Lv 5
Jets Fan asked in Computers & InternetSoftware · 6 years ago

Help with Excel Macro?

Update:

I have a worksheet with a horizontal check box list. I want write a macro that enables the cell at the end of the list to turn green and display "Yes" in that cell when are check boxes are selected and turn red and display "No" when one or more check boxes are not selected. Thanks

1 Answer

Relevance
  • garbo7441
    Lv 7
    6 years ago
    Favorite Answer

    Edit: you really don't have to use a macro to do as you wish. As you have the check boxes 'floating' over the grid, each over a specific cell, just link each check box to the cell below it. Then, you can use conditional formatting on cell B12, using a formula:

    =COUNTIF(B4:B11,TRUE)=8

    Format the cell Green

    =COUNTIF(B4:B11,TRUE)<8

    Format the cell Red

    Note: you can use the same formulas for the cell to return 'Yes' or 'No'.

    =IF(COUNTIF(B4:B11,TRUE)=8,"Yes","No")

    Repeat for each group of check boxes. Hide the column containing the linked references.

Still have questions? Get your answers by asking now.