Excel Forum
Similar Content
8 Tips to Become an Expert in Conditional Formatting for Excel
Tutorial: Become a master of Conditional Formatting in Excel! This tutorial covers 8 tips and trick...
Make Complex Formulas for Conditional Formatting in Excel
Tutorial: How to make complex formulas for conditional formatting rules in Excel. This will serve as...
Multiple Conditional Formatting Rules for a Cell in Excel
Tutorial: Apply multiple Conditional Formatting rules to a cell or range in Excel. This allows you ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




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.