Is it possible to do an OR with an AND in each using conditional formatting

[suprsnipes]

Hi,

Is it possible to do the following using conditional formatting?

=AND($P3>$O3,$R3<$P3)

OR

=AND($P3<$O3,$R3<$P3)

Regards,
suprsnipes

 

[Jonmo1]

Yep, try

=OR(AND(...,...), AND(...,...))

 

[Jonmo1]

After further review of the logic, this should suffice

=AND($R3<$P3,$P3<>$O3)

 

[suprsnipes]

Much appreciated, thanks