6 Replies Latest reply on Aug 5, 2016 2:01 PM by GeraldJourneau2489

    What would be the correct formula for finding a value containing certain text?

    GeraldJourneau2489

      When you choose conditional formatting for a field, you can have it find choose a [ value is containing "2 of 3" ] and have the field be BOLD and that is fine but  I need the field to enter  "100" in it. Tried to use a  formula where it will find within the text field containing these characters "2 of 3" with a line which can be " 2 of 3 - 44 Mentor St NE" , What would be the correct formula.