Excel Forum



Excel Magic Trick #110: Partial Text Conditional Formatting


See how to use the MID, SEARCH, FIND and LEN functions in a TRUE FALSE formula for Conditional Formatting. See how to add formatting when only part of the text srting meets the criteria. For example, highlight when ped in somewhere in a text string like The ped is OK.S





Got a Question? Ask it Here in the Forum.