Adding am OR function to my script

[DcoltTech]

Hi there,

I currently have a script set up, that highlights a row when a value is true. I would like to set it other values as well.

My Current script:

=$B2="English Revision DVD (Single User)"

What I would like:

=$B2="English Revision DVD (Single User)", OR English Revision Student Workbook, English Revision DVD (Site Licence)

How would I go about doing this?

Thanks in advance

 

[Rick Rothstein]

Try it like this...

=OR($B2="English Revision DVD (Single User)",$B2="English Revision Student Workbook, English Revision DVD (Site Licence)")

 

[DcoltTech]

Thank you..it works perfectly

Try it like this...

=OR($B2="English Revision DVD (Single User)",$B2="English Revision Student Workbook, English Revision DVD (Site Licence)")