Conditional Formatting with nested IF, OR & AND

[tammorice]

Hi everyone. I am trying to format a cell based on a couple of conditions.

$N13= formatted when

1. $C13="CharterB" OR "CharterKP" AND
2. $F13 < 04:00 OR $F13 > 22:00

This is what I have tried, but it is formatting everything with $C13= CharterB or CharterKP and not just when the hours = those at point 2 above.

=IF(AND(OR($F13>"22:00",$F13<"04:00")),(AND(OR($C13="CharterB",$C13="CharterKP")))

Thanks for your help.
Tam

​

 

[AhoyNC]

Try:

[TABLE="width: 436"]
<colgroup><col width="436"></colgroup><tbody>[TR]
   [TD="width: 436"]=AND(OR(C13="CharterB",C13="CharterKP"),OR(F13<4,F13>22))[/TD]
 [/TR]
</tbody>[/TABLE]