Explore and use preset rules for conditional formatting Thanks to Microsoft’s preset rules, you don’t necessarily need to create a custom rule from scratch.

B. Format cells that contain specific text You can also use the Conditional Formatting feature to make certain text (letters, word, phrases, etc.) stand out.

Learn how to master Excel 365 conditional formatting to transform raw data into actionable insights with this step-by-step guide.

Create additional conditional statements by highlighting the same cells, clicking the "Conditional Formatting" button again and making another selection. Save the workbook when you are finished.

If your subtotaling rows are lost in a sea of worksheet data, use this simple conditional formatting technique to make those rows easy to spot.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

Susan Harkins shows you how to visually identify holidays using Excel's conditional formatting feature.

If you run into a conditional header or footer request that you can't handle, take a look at Word fields. They're not magic, but it kind of feels like magic when they do what you want.

We've covered a lot about using custom formulas for conditional formatting in Google Sheets, especially color-coding cells based on the date. Now let's look at how to color-code cells based on whether ...

Common wisdom says you just can't apply conditional formatting in a Google Apps spreadsheet using data from a different sheet. But here at THE Journal, we laugh in the face of wisdom, common or ...