Conditional Formatting Help - (empy cell or matching = no formatting while non matching is formatted)

[maximillianrg]

I’m looking for some help with conditional formatting

Cell A1 contains the number 5
Cell B1 is empty and is the cell I want to apply the conditional formatting to based on what is entered into B1

If cell B1 is empty then no conditional formatting is applied
If user enters content into B1 that is equal to cell A1 then no formatting is applied
if user enters content into B1 that is not equal to A1 then conditional formatting is applied

I can make this work with 3 seperate conditional formatting statemens but was wondering if a formula could be used, something like

=IF(B1="","",IF(B1=A1,"","X"))

Where "" is no formatting and X is formatting

Thanks so much

PS : I can't use Macro's or VB

 

[JoeMo]

Does this CF formula do it?

=AND(B1<>"",B1<>A1)