Share via

how do i create a long interactive checklist in excel?

Anonymous
2024-10-26T18:52:14+00:00

I have a long list of items. About 700. Each with a checkbox. I know how to apply Conditional Formatting, where the two cells are linked. Such as if the checkbox in B1 is checked, the item in C1 is highlighted.

My question is, is there an easy way to apply Conditional Formatting such as this, where if you check the box in column B, the item next to it in column C is highlighted, without having to apply the Conditional Formatting to each individual cells all the way down to B & C700?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

  1. HansV 462.6K Reputation points MVP Volunteer Moderator
    2024-10-26T19:18:04+00:00

    Select C1:C700. C1 should be the active cell in the selection.

    On the Home tab of the ribbon, click Conditional Formatting > New Rule...
    Select 'Use a formula to determine which cells to format'.
    Enter the formula

    =$B1

    Click Format...
    Activate the Fill tab.
    Select a fill color.
    Click OK, then click OK again.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2024-10-26T19:47:44+00:00

    oh my word.... thank you!!! you are a lifesaver!!!

    0 comments No comments