1

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.

sample sheet: https://docs.google.com/spreadsheets/d/1yPUUr24hAwFFcfWKdaknEA3vBmIvDNpscobLbMcHHtU/edit?usp=sharing

example

qazamy
  • 47
  • 7
  • How you will detect missing dates as dates are entered as string in one cells. – Harun24hr Oct 22 '21 at 05: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 Oct 22 '21 at 05:14
  • Questions should be self contained. While external links are welcome(note: *Google sheets exposes your email address*), consider adding a [table](https://meta.stackexchange.com/questions/356997/) or screenshots or csv text(like [this](https://stackoverflow.com/a/64186520/)) to show your data structure. – TheMaster Oct 22 '21 at 08:42

1 Answers1

2

Try:

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

enter image description here

basic
  • 11,673
  • 2
  • 9
  • 26
  • Hi @basic, could you please assist with this new iteration of the above conditional formatting issue? - https://docs.google.com/spreadsheets/d/1yPUUr24hAwFFcfWKdaknEA3vBmIvDNpscobLbMcHHtU/edit#gid=1956802292&range=A1 – qazamy Oct 29 '21 at 09:47
  • @qazamy A different and more complex solution will be needed here, so ask a new question. – basic Oct 29 '21 at 10:18
  • Thanks, @basic! Just submitted it - https://stackoverflow.com/questions/69768759/ – qazamy Oct 29 '21 at 12:19