Learn how to fix Excel conditional formatting issues with dynamic references, OFFSET function, and defined name method for clean spreadsheets ...

Image: monticellllo/Adobe Stock The article, How to use a border to discern groups more easily in Microsoft Excel, shows you how to use a conditional formatting rule to apply a red border between ...

Microsoft Excel’s RANK.EQ() function ranks a set of values, but in a busy sheet, the top-ranking items might get lost. You can combine RANK.EQ() with a conditional formatting rule to highlight ...

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

You can achieve this using the TODAY and IF functions in a conditional formatting rule and then applying a red fill.

Launch Microsoft Excel. Select the entire range of columns along with the rows. Apply Conditional Formatting to the selected range of rows and columns. Click OK. Let’s see the above steps in ...

If the contents are a number-even if it is formatted as text by Excel-then the formula returns True, and the condition is met for the formatting.

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.