## 'OR function' category

How to track sector performance in the stock market – Excel template

The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]

The image above shows the performance across industry groups for different date ranges, conditional formatting makes the table much easier […]

How to filter using OR logic between columns [Formula]

The filter feature in Excel won't allow you to do OR logic between columns, however, you can if you allow […]

The filter feature in Excel won't allow you to do OR logic between columns, however, you can if you allow […]

If cell equals value from list

This article demonstrates formulas that check if a cell value is equal to any value in a given list. Table […]

This article demonstrates formulas that check if a cell value is equal to any value in a given list. Table […]

If cell contains text from list

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

This article demonstrates several ways to check if a cell contains any value based on a list. The first example […]

IF with OR function

This article shows examples of how to use the IF function with the OR function. Table of Contents IF with […]

This article shows examples of how to use the IF function with the OR function. Table of Contents IF with […]

How to use the OR function

The OR function allows you to carry out a logical test in eachÂ argument and if at least one argument returns […]

The OR function allows you to carry out a logical test in eachÂ argument and if at least one argument returns […]

Use a calendar to filter an Excel defined Table

This article demonstrates how to filter an Excel defined Table based on the selected cell in a calendar. The calendar […]

This article demonstrates how to filter an Excel defined Table based on the selected cell in a calendar. The calendar […]

Find numbers in close proximity to a given number

This article demonstrates how to apply Conditional Formatting formula to a cell range, it finds cells that are in close […]

This article demonstrates how to apply Conditional Formatting formula to a cell range, it finds cells that are in close […]

Highlight closest number

This post demonstrates how to highlight records with the closest value to a criterion, you can also choose to highlight […]

This post demonstrates how to highlight records with the closest value to a criterion, you can also choose to highlight […]

Setting up your work hours in a weekly schedule

The image above demonstrates conditional formattingÂ highlighting hours outside work hours, those cells are filled with grey except weekends. Conditional formatting […]

The image above demonstrates conditional formattingÂ highlighting hours outside work hours, those cells are filled with grey except weekends. Conditional formatting […]

Automate net asset value (NAV) calculation on your stock portfolio

Introduction In this post I am creating a spreadsheet that will calculate stock portfolio performance. To do this I am […]

Introduction In this post I am creating a spreadsheet that will calculate stock portfolio performance. To do this I am […]

Dynamic formatting

Question: I have a list that I keep adding rows to. How do i create a border that expands as […]

Question: I have a list that I keep adding rows to. How do i create a border that expands as […]

Highlight every other row

Here is how to highlight every other row using conditional formatting. Conditional formatting formula: =ISEVEN(ROW())*OR($B3:$D3<>"") Alternative CF formula: =EVEN(ROW())=ROW() This […]

Here is how to highlight every other row using conditional formatting. Conditional formatting formula: =ISEVEN(ROW())*OR($B3:$D3<>"") Alternative CF formula: =EVEN(ROW())=ROW() This […]