Here's how you check for one cell meeting either condition:
=if((or(c5="=20/24",c5="=18/24"),"yes","no")

The first thing to do is check this out to see if it works for you.

If it does, then we can work on the entire range.

Regards,
Fred

"YS1107" wrote in message
...
The formula I have now, the time looks like for 8pm (=20/24) and 6pm
(=18/24). The times are choosen by a drop down list. The time range for
this
formula is until 12am (midnight). The formula I have tried is
=IF($C$5:$C$6,$E$5:$E$6,$G$5:$G$6,$I$5:$I$6,$K$5:$ K$6,$M$5:$M$6,$O$5:$O$6)=20/24and=18/24
and some other variations of it but none seem to work. Its says "Too many
arguments". At the present moment I am still trying to figure it out.

Thanks for helping me

"Fred Smith" wrote:

What does an 8pm time look like? What does a 6pm time look like? Do your
cells have times in them, or text? Do you mean any time between 8pm and
9pm,
or some other range? Same for the 6pm time.

Regards,
Fred.

"YS1107" wrote in message
...
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.