Conditional Formatting Based on Formula - (Value in another Cell) AND, ISTEXT, ISFORMULA, ISNUMBER

📽️In this Microsoft Excel video tutorial I demonstrate how to create conditional formatting based on a formula. Formulas need to be a logical test - resolve to TRUE or FALSE. You can do this with comparison operators and functions. Formulas can be based in values in another cell. Logical tests can contain multiple criteria using either AND or OR. 👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted... Thank you! 👍👍 🕰️ Timestamps 00:00 Introduction 00:05 Using the AND function for multiple conditions 04:19 Using ISTEXT to identify incorrect dates 06:24 using ISFORMULA to identify formula cells 07:05 Using LEFT for begins with criteria 08:20 Using SEARCH & ISNUMBER for contains text #exceltips #exceltricks #exceltutorial