1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

If false, then fill row formula help please on the web based version of excel

Our take

Managing a master event tracker in Excel can become cumbersome, especially when trying to ensure all events are categorized correctly. In this scenario, you're looking to highlight entire rows when no checkboxes in columns L through W are selected, making it easier to spot unassigned events. This functionality can streamline your workflow and enhance visibility in a busy spreadsheet. Let's explore how to set up conditional formatting to achieve this goal, ensuring that your event list remains organized and user-friendly.

I’ll just get right to it: So it’s basically a master event tracker. columns A through K are text information/number counts A is *event title*, B is location, etc. just general information, each event gets its own row.

columns L-W are check boxes for standard categories of events: column L is marketing/promotional meeting, staff meetings, collaboration events, etc. if it falls within that scope it gets a check box for that column.

I am trying to figure out how to highlight the whole row if NO check boxes in L-W are checked. This is our master events list so it gets pretty bulky month to month and it’s easy to miss if it hasn’t been assigned a category.

Everything I’m doing seems to either not highlight the row at all or highlight it unless all of the check boxes in L-W are clicked.

submitted by /u/Wtfevenarepeople
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article