How would I loop through open excel workbooks and if the cell A1 contains the word 'August, color A1 cell red. if A1 contains the word 'September' color it in blue.
Must loop though workbooks.