- Openoffice conditional formatting based on multiple cells how to#
- Openoffice conditional formatting based on multiple cells windows 10#
- Openoffice conditional formatting based on multiple cells download#
Enter the formula =OR($D3($C3+60)+3) in the lower pane.In the resulting dialog, click the Use A Formula To Determine Which Cells To Format option in the top pane.Choose New Rule from the Conditional Formatting dropdown (in the Styles group).Select D3:D6, the range of actual dates.To implement the formatting rule, do the following: There’s a reason for both the 60-day and +/- window, and either or both could change. Cutting corners often works, but it can have unexpected consequences that are hard to troubleshoot down the road. We could reduce the integers to 57 and 63, but we’re staying true to the specifications. The simple expressions in columns E and F follow: Figure A A conditional formatting rule highlights dates outside the expected window. The expressions in columns E and F return the +/- dates for each contract date you don’t need them, but they help illustrate what’s happening. Translated into an expression, you end up with the following syntax:įigure A shows this expression in use. The expected date is implicit–it doesn’t exist in the sheet. When the actual fulfillment date is outside the theree-day +/- window based on the expected date, she wants the actual date highlighted. Sarina has three dates: a date where counting begins, the contract date, and a date where counting might end, a 60-day expected fulfillment date.
![openoffice conditional formatting based on multiple cells openoffice conditional formatting based on multiple cells](https://i.stack.imgur.com/UiIn9.png)
SEE: Build your Excel skills with these 10 power tips (TechRepublic download) Accommodating what you have Excel’s browser version supports existing conditional formatting, but you can’t apply a formulaic rule in the browser.
Openoffice conditional formatting based on multiple cells download#
For your convenience, you can download the demonstration.
Openoffice conditional formatting based on multiple cells windows 10#
I’m using Excel 2016 (desktop) on a Windows 10 64-bit system, but this solution will work in earlier versions. To be fair to Sarina, her requirements are more complex than the solution I’m sharing, but the concept is the same. You’ll also see two solutions: one that satisfies the requirements and a second that’s more flexible.
Openoffice conditional formatting based on multiple cells how to#
In this article, I’ll show you how to use an OR() operator to evaluate the two ends of the three-day window and the 60-day conditions. How to create a fun Fly In effect in PowerPoint
![openoffice conditional formatting based on multiple cells openoffice conditional formatting based on multiple cells](https://images.g2crowd.com/uploads/product/image/large_detail/large_detail_170984fbbcfa0186045081d46bc7186c/apache-openoffice-calc.jpg)
Learn advanced Excel skills for less than $35
![openoffice conditional formatting based on multiple cells openoffice conditional formatting based on multiple cells](https://www.easy-insight.com/images/help/conditional_formatting_background_color.png)
When the actual fulfillment date falls outside of a three-day window (either way), she wants a conditional format rule to highlight the fulfillment date. Sarina inherited a workbook that stores a contract date with an expected fulfillment date that’s always 60 days out. They try, but they simply can’t get all the pieces to work together correctly. Here are two ways to apply a complex conditional format to accomplish a tricky goal.Įxcel’s conditional formatting feature confuses a lot of readers. Office Q&A: A conditional formatting rule with multiple conditionsĬonditional formatting is a powerful and useful Excel tool-but not everyone understands how to put it to work.