I'm working with Google Sheets and want to highlight cells in long date format (e.g. 11/13/2018 21:00:00) that are Tuesday and 21:00:00. Here is my attempt:
What I understand this to say is "if the weekday is Tuesday AND the eight characters at the end of the cell is equal to 21:00:00, then highlight."
What might I be missing in getting this to work properly?