Conditional Formatting multiple cells based on multiple dates in a single cell

Question

I'm trying to highlight, via conditional formatting, multiple cells in column G2:Z based on the multiple dates in single cells in column C2:C.

How you will detect missing dates as dates are entered as string in one cells. — Harun24hr
– Harun24hr, Commented Oct 22, 2021 at 5:09
@Harun24HR sorry, not quite sure what you're saying here. But =SPLIT(C3,CHAR(10)) will be able to split each date into separate cells. — qazamy
– qazamy, Commented Oct 22, 2021 at 5:14
Questions should be self contained. While external links are welcome(note: Google sheets exposes your email address), consider adding a table or screenshots or csv text(like this) to show your data structure. — TheMaster
– TheMaster, Commented Oct 22, 2021 at 8:42

basic · Accepted Answer · 2021-10-22 09:18:49Z

2

Try:

=ArrayFormula(OR((SUBSTITUTE(SPLIT($C2, CHAR(10)), ".", "/")*1)=G$1))

answered Oct 22, 2021 at 9:18

basic

12k2 gold badges15 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Hi @basic, could you please assist with this new iteration of the above conditional formatting issue? - docs.google.com/spreadsheets/d/…

@qazamy A different and more complex solution will be needed here, so ask a new question.