Conditional Formatting based on a few different possibilities?

[danbates]

Hi,

I was wondering if it is possible to have a formula to do the following in conditional formatting.

If A1 value is "JP" or "GB" and E1 has a value of either <244 or >265 the cell turns red.

Any help would be much appreciated.

Thanks

Dan

 

[Peter_SSs]

Try this formula in CF
=AND(OR(A1="JP",A1="GB"),OR(E1<244,E1>265))

 

[danbates]

Hi Peter,

It's perfect once again. Thank you.

Regards

Dan

 

[Peter_SSs]

Thanks for letting us know.