I have a formula that I want to write that the cells meet the conditional
format for times of day. I struggle to figure the "correct" language in an
excel formula.

I am struggling to write a formula for cells B5:O6 that if cells
C5:C6,E5:E6,G5:G6,I5:I6,K5:K6,M5:M6,O5:O6 have at least one 8pm time AND at
least one 6pm time (or later) the cells are green.

or if the cells have at least one 8pm or 6pm (or later) then all cells are
yellow

or if the cells have none of these conditions then all cells are red.

If anyone can enlighten me it would be much appreciated.

I know this involves "AND" and "OR" but I struggle with the correct format.