HELP with counting cells that contain a fill

New Contributor

So my goal here is to create a formula in the far right Column labeled Valid/Not Valid, that determines if any cells within the row contains a fill. Most of the columns themselves have conditional formatting and since I cannot sort by due to not all the fills lining up, I am unsure how to go about it. The formula needs to search the entire row and, whether it be 1 or any number of individual cells within the row containg a fill, determine if its valid or not valid. Any help, if this is even possible, would be appreciated. Telework Snip.JPG

2 Replies



If you use formulas for your conditional formatting rules you shall have one such formula per column, or even per few columns if they have the same criteria. You may combine all these formulas in helper column with AND condition and return Valid/Not valid depends on results.

If you use rules where formulas are not shown in interface you may formalise your rules into the formulas yourself. You have some logic behind which could be translated into formulas.

If to check based on colors only that's VBA coding.

Thanks for the respones. Any idea how to use the VBA to determine color based on rows containing a cell? I know the basics of VBA but have not seen a formula to determine if a row contains a color and then get it to output a VALID/NOT VALID based off that? Hopefuly that question makes sense.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies