Sheet called "Forecast" - column F goes from 0:00 to 23:30 in 30min increments (F3:F50)
Sheet called "Forecast" - column N populates as the day goes by and gives a % based on a formula (N3:N50). Column N has conditional formatting based on 2 specific criteria that will fill some cells with a light red.

What I would like to do is take the particular N cells that end up turning red, combined with the F cells, which will tell me when that particular time frame occurred, and put them on a sheet called "Comments".

So on the Comments sheet, I could end up with a sentence like this...
"9:30am was 150%, 10:30am was 2100%, 7:30pm was 141%"

Does anyone have any ideas?