How to use OR in Conditional Formatting?

[jkeyes]

Sorry, "OR" is too short of a word to search on here and I wasn't finding any threads that discussed this specifically...

I just need to know how to have a cell conditionally formatted so that it formats if another cell's value is x OR y... pretty simple, I'm sure, I've just never done it and can't seem to figure it out.

I'm on Excel 2003, if that makes a difference. Thanks!

 

[jkeyes]

Nevermind... the original solution I thought it was (second condition) just wasn't working for some reason but is now... thanks anyway!

 

[barry houdini]

If you want to format A1 if B1 is "X" or "Y" then slect A1 and apply conditional formatting using "formula is" option and the formula

=OR(B1="X",B1="Y")

 

[VoG]

You can use Formula Is and a formula like

=OR(A1="Yes",A1="Maybe")