I've been trying to figure out how to make it so that based on a date on "December 2022" the conditional formatting will look at "Data" to see if the date exists in B. That part I have nailed down no problem, where I can't make this work is I also want to have in the same formula a secondary check that matches the header for the given date to the "Data" page where the exact same data point gets populated. On "December 2022" I've already set up my conditional formatting to black out when something shouldn't be posted. It's figuring out how to pull the data from the checkbox on "Social Posts" which automatically copy the data over to "Data" that I'm at a complete loss for.

Looking around in various places I've tried a few that seemed like they may work, but adding in the second condition breaks it instantly.

=ArrayFormula(countif(indirect("Data!$B$2:$B"),$A2:$A))>0
=match(N1,indirect("Data!A1:A"),0)
=if(A14,indirect("Data!B1:B"),0)

=indirect("Data!B1:B"),A36=indirect("Data!A1:A")).

=INDEX(REGEXMATCH(A14, TEXTJOIN("|", 1, 
 FILTER(INDIRECT("Data!C:C"), INDIRECT("Data!A:A")=TRUE))))