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.

=COUNTIF(indirect("Training Classes!$E:$E"),A1)>1

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.

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.

COUNTIF(indirect("Training Classes!$E:$E"),A1)>1

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.

I have a calender 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, hope I can be helped :).

COUNTIF(indirect("Training Classes!$E:$E"),A1)>1

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 thats having issues.

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.

=COUNTIF(indirect("Training Classes!$E:$E"),A1)>1

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.