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

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]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#row zero
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#rows.com
#Excel alternatives
#real-time data collaboration
#real-time collaboration
#AI formula generation techniques
#cloud-based spreadsheet applications
#formula generator
#event tracker
#Excel
#columns
#checkboxes
#master events list
#event title
#location
#highlight row