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

Conditional formatting based on a checkbox

Howdy y'all. I'm trying to format a spreadsheet being used for a golf outing. It's not a big deal, but it will satisfy my OCD if I can click my "PAID" checkbox, and it will highlight the row with the person who has paid. Should be fairly simple and straight-forward, but it's giving me some headaches.

So far with all of my formatting, I've been able to just use IF statements to make everything work, but in this situation, it's not going to work that way.

Excel AND the internet want me to just use the formula in the conditional formatting window =M7=TRUE (and obviously cascade this down for each line beyond 7), however this is only highlighting the initial cell; when selecting B7:I7, the formula will only cause B7 to format, and the rest will not, even though when I click on each individual cell, it's showing that the formula is applied to those other cells.

I'm really trying to not have to individually format like 500 cells if I can avoid it.

Also, if I cannot come to a solution, I guess I will just suffer without the highlighting. lol

Thanks ahead of time!

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#AI formula generation techniques
#formula generator
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#financial modeling with spreadsheets
#Excel alternatives
#rows.com
#cloud-based spreadsheet applications
#big data management in spreadsheets
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#row zero
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#real-time data collaboration
#automation in spreadsheet workflows