Step 2: Click on Conditional formatting and New Rule. In order to do this task, we need to apply the formula in the conditional formatting tab. Here I want to highlight the departments of Marketing and IT. I have an employee’s database with name, salary, and their respective department.
#Outlook conditional formatting not statement how to
In this example, I will explain to you how to highlight rows based on multiple values. In our previous examples, we have learned how to highlight based on the single-cell value. It will highlight all the Active row employees.Įxample #2 – Excel Conditional Formatting Based On Another Cell Value Now try changing the cell value in C1 from Left to Active. Step 6: Again, click on OK to format the rows if the cell value is equal to the text Left. Step 5: Select the formatting color by clicking on the Fill option and then click OK. If the B2 cell is (this is not an absolute reference, but the only column is locked) equal to the value in the C1 cell (this is an absolute reference), then do the formatting. Step 4: Next, under the formula bar, mention the formula as shown in the below image and then click on Format. This select Use a formula to determine which cells to format. Step 3: Once you click on that option, it will open a new window for you. Go to Home > Conditional Formatting > New Rule. Step 1: Mention the text Left in cell C1. Under this method, I will show you how to highlight an entire row based on the single-cell value. In the previous example, we have seen how to highlight a single cell based on the cell value. Method #2 – Highlight Entire Row Based on One Single Cell Value Step 4: You can already see the preview of this task on the left-hand side of your window.
![outlook conditional formatting not statement outlook conditional formatting not statement](https://earnandexcel.com/wp-content/uploads/Conditional-Formatting-in-Excel-11.png)
I have mentioned the text as Left and chosen the formatting as Light Red Fill with Dark Red Text. Click on the OK button to complete the task. In this window, mention the text value that you want to highlight. First up we are going to keeping this simple.Step 2: Go to Home > Conditional Formatting > Highlight Cells Rules > Text That Contains.In cell F1 I will use a formula to calculate the date range I want to use.In my example, I have put the label “ Date” into cell E1.
![outlook conditional formatting not statement outlook conditional formatting not statement](https://www.howtogeek.com/wp-content/uploads/2018/09/2018-09-26.png)
![outlook conditional formatting not statement outlook conditional formatting not statement](https://support.content.office.net/en-us/media/f72b581a-7063-4f6b-a371-b7524587f3a3.jpg)
I have had plenty of questions and comments based on this post. This post talks about how to conditional format dates within occur in the past. My conditional formatting to identify dates earlier than today post has proven to be extremely popular.