I have a calendar put into Google Sheets with the data put in as dates such as "9/24/2018".
I have a separate sheet with a data set that has rows that classes end such as "9/24/2018".
I want to conditionally format the entire calendar so that if any cell in the calendar has a date that matches one in the data set it will format.
I'm using this formula so far, but no dice. Not sure what I'm doing wrong.
The calendar range is B6:X37 just in case that matters.
For the record, the formula does work if I assign it to a specific cell and put it in a cell.
So if I put somewhere
=COUNTIF(indirect("Training Classes!$E:$E"),S27)>1) then it is true. Its just the conditional that's having issues.