Bold text and highlight cell for new classrooms

Hi,
I'm trying to bold and highlight every time a new classroom is reported in my excel table. How do I automate this? I have many classrooms.
This is my excel sheet:

Classroom season Q1 Q2 Q3 ...
Classroom A winter 45 67 32 89
Classroom A fall 45 86 34
Classroom A spring 45 98 5 32
Classroom B winter 68 21 98
Classroom B fall 67 98 27
Classroom B spring 98 32 90

etc...

What I would like is the following (I can bold but can't highlight the cells in this post!):

Classroom season Q1 Q2 Q3 ...
Classroom A winter 45 67 32 89
Classroom A fall 45 86 34
Classroom A spring 45 98 5 32
Classroom B winter 68 21 98
Classroom B fall 67 98 27
Classroom B spring 98 32 90

Thanks!

Hi, thank you for responding so quickly. This is the data said that I have. I did not manually enter this information. I have no VBA skills. Are you saying this is possible to do in VBA?

I found an article to use conditional formatting to create a custom rule. I use this formula =COUNTIF(A$1:A1,A1)=1 but it only highlights the cell. How do I change the formula or the conditional formatting to highlight rows instead of cells?

Conditional formatting

=ISNUMBER(SEARCH("winter",$A2))

format

font stile bold

applies to =$A$2:$A$100