By changing the Applies to range, however, you can easily highlight a different cell – such as the birthdate – or the entire row. Then, create a second rule for the same range using this formula to highlight birthdays that are not in your department:īONUS! In this example, we applied the rule to the department cell to show the relationship to the formula. If you are reproducing the exercise in a different month, you will see different results! This example was created in April, so April birthdays will be highlighted. To create a formula that generates a TRUE/FALSE statement that highlights birthdays only in one department, you would use the formula: The formula to identify birthdays in the current month will be ( see this article for more about using dates in conditional formatting): Step 1 – Highlight birthdays in your department Solution: Create two rules – one for your department, one for all others Scenario 1 (Birthdays tab): You want to highlight all employees in your department who have a birthday this month with Red, and all other departments blue. To follow using our examples, download 04-If-Then Conditional Formatting. Let’s look at a few scenarios to get a sense of how we can create the effect of IF/THEN conditional formatting, even if we can’t use it in the feature itself: Instead, this would require TWO rules, one for “greater than 10” and one for “less than 10”. What conditional formatting can’t do in a single rule is an IF/THEN/ELSE condition such as “If # is greater than 10 format red, else format green”. Any conditional formatting argument must generate a TRUE result, meaning that at a literal level, your conditional formatting rule is an If/Then statement along the lines of “If this condition is TRUE, THEN format the cell this way”. A question that often comes up among these “conditional formatting addicts” is Can I use If/Then formula to format a cell? If you are a fan of Excel’s conditional formatting feature, you probably find looking for even more and more ways to highlight useful information in your data. *Steps in this article will apply to Excel 2007-2016. By Tepring Crocker Categories: Conditional Formatting, Excel® Tags: If/Then Conditional formatting

Can i do an if then formula in excel