Help with Conditional formatting when two field matches exist

[beckham]

conditional

Quote

Hi Can anyone advise me please ?

I am trying to work out how to create conditional formatting only when TWO different fields match my criteria.

iE: if the fields "Mr" and "Mrs" exist = No conditional format required.

If the field "Mrs" and "Mrs" exist Conditional formatting is required.

Thank you for any advise offered.

 

Ok as often I have answered my own question, for any newbies with  the same question.

formula = field A = "Mrs" and field B = "Mrs"

[Ocean West]

One thing to consider as long as users can't type in other characters such as periods or spaces and the "Mrs" is only available from a drop down list than the above approach is valid.

Another approach

 Exact ( FieldA ) = Exact ( FieldB )