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 |
[link] [comments]
Want to read more?
Check out the full article on the original site