Help with conditional formatting

[Sean15]

Hi:

I want to do a conditional format based on the following:

If value in range A2:A60 is equal to 1301, or 1305, or 1306, or 1307, format corresponding value in range F2:F60.

So if A2=1301, format F2

If A2=1320, no format in F2

Could someone help with a formula please?

Regards,

Sean

 

[Jeffrey Mahoney]

Hi Sean,

Please try this. Highlight the cells F2:F60. Create a new conditional formatting that uses a formula to determine which cells to format. Enter this formula:
=AND($A2>1300,$A2<1308)

Formulas in conditional formatting all have to result in a TRUE or FALSE
Jeff

 

[Jeffrey Mahoney]

I didn't see that you don't want to use all the values between 1301 and 1307 as a value so...

=OR($A2=1301,$A2=1305,$A2=1306,$A2=1307)

 

[Sean15]

Hi:

Post#3 is set up exactly as I want and gives he required results.

Thanks very much.


Regards,

Sean