date conditional formating excel for mac

Date Conditional Formating Excel Download The Working

Excel Conditional Formatting makes it easy to highlight data in your worksheets.

In this article, we will see different processes of highlighting cells that contain text using conditional formatting.

Date Conditional Formating Excel Download The Working

Table of Contents Highlighting Cells Based on Another Cell Text with Formula Excel Conditional Formatting Entire Row Based on One Cell Text Highlight cells containing specific text using Highlight Cells Rules Another Process of Highlighting Text using Conditional Formatting Download The Working File Conclusion Highlighting Cells Based on Another Cell Text with Formula You can use the search option to highlight specific cells in conditional formatting.

In this case, we will be identifying the cells containing the word Passed.

Here in B2 cell, we have the text which is displaying Passed the Exam.

We will be targeting this cell to perform the conditional formatting for the entire range of cells.

Select the range of cells where you want to apply the conditional formatting.

Now, select the New Rule from Conditional Formatting option under the Home.

In the New Formatting Rule dialogue box select Use a formula to determine which cells to format and type SEARCH(C2, A1)0 in Format values where this formula is true box.

Click on to the Format option to open the Format Cells dialogue box.

In the Format Cells dialogue box under the Fill option, select the color you want and press OK.

After this, you can see the color you choose in the Preview option.

Now press OK in the New Formatting Rule dialogue box to apply the formatting.

In the same way, if you want to find the students who failed the exam but can sit for a retake you just need to write Retake instead of Pass in cell C2.

Note: The formula SEARCH(C2,A1)0 will highlight all cells where the word Retake is located whereas the formula SEARCH(C2,A1)1 will highlight only the cells which start with the word Retake.

Excel Conditional Formatting Entire Row Based on One Cell Text Lets say you want to highlight the names of the candidate along with the status of the final exam.

So, in the New Formatting Rule dialogue box, we will use this formula.

After pressing OK in the New Formatting Rule dialogue box, we will get the below result.

Note: Dont forget to select the range before applying the conditional formatting.

Highlight cells containing specific text using Highlight Cells Rules Conditional Formatting makes it easy to highlight the cells which contain some specific text.

From them, you want to highlight the colors red, yellow and green.

Lets highlight the colors red, yellow and green from the above list.

First, select the cells from which you want to perform the highlighting.

Now, Under the Home tab select the Conditional Formatting option.

Date Conditional Formating Excel For Mac