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

how to flag cell with conditional formatting, if one criteria is false out of a batch of true/false?

Hi reddit,

Pretty sure there's an easy way to do this, but I can't seem to figure it out 😅

I have a spreadsheet that tracks information as it flows through our company processes. The format is:

col a - starting date
col b - task label
col c-g - checkboxes that show what's been done
col h - a nested IF formula that checks what's going on in b-g.
col i - TRUE/FALSE based on the col h value

col h drives conditional formatting that will turn rows different colors based on combinations of b-g values. this allows me to use a filter on a color and quickly see all tasks that are at the same step. once all tasks are completed, col h will say TRUE for that row and there is no formatting. i will be FALSE for any value in h that isn't TRUE.

all tasks are organized by dates in col a. once a month has ended, there's a row labeled "ending" in col b with a summary of the month's activity.

what I'm looking for is a conditional formatting formula I can use that will flag the "ending" row if any rows with the corresponding month do not have TRUE in col i. ideally I'd like to keep the formulas in col h-i intact, but I could add a helper column in col j.

Thanks!

A B C D E F G H I
6/1/26 task 1 TRUE TRUE TRUE TRUE TRUE TRUE TRUE
6/5/26 task 2 TRUE TRUE TRUE TRUE TRUE
6/6/26 task 3 TRUE TRUE FALSE f hold FALSE
6/8/26 task 4 FALSE TRUE TRUE TRUE FALSE c/g hold FALSE
6/30/26 Ending TRUE TRUE
submitted by /u/One_Surprise_8924
[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
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#row zero
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#AI formula generation techniques
#formula generator
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#Excel compatibility
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#Excel alternatives