Conditional formatting is evaluated relative to every cell it is applied to, starting with the active cell in the selection, cell B3 in this case.To highlight matching rows, we use this logical expression:$B4=$K$5...
In the example shown, we want to mark or 'flag' records where the color is red OR green. In other words, we want to check the color in column B, and then leave a marker (x) if we find the word 'red' or 'green'. In D6,...
This formula uses 4 named ranges, defined as follows:width=K6height=K7widths=B6:B11heights=C5:H5Conditional formatting is evaluated relative to every cell it is applied to, starting with the active cell in the...
This formula uses the WEEKDAY function to test dates for either a Saturday or Sunday. When given a date, WEEKDAY returns a number 1-7, for each day of the week. In it's standard configuration, Saturday = 7 and Sunday...
Excel Without Mouse
Excel will automatically recognize the regions and create a map that visualizes the data. To create a map chart, select the data you want to chart, then select Insert Maps, then select the. Formatting cells using Excel shortcuts is a lot faster than choosing options from menus. These are the most useful ones to know: Formatting and editing cells on a PC.
2021 Excel Calendar Templates with popular and US Holidays. Calendar files are in xlsx (macro-free) format and compatible with Google Docs and Open Office Calc. Calendars are blank and printable. They are ideal for use as a spreadsheet calendar planner. Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. Take your analytics to the next level with Excel.
This formula relies on a technique called 'nested IFs' to handle a series of options and results. With nested IFs, one IF function is nested inside another, a process that is explained in some detail here.The formula...
In the example shown, we want to 'mark' or 'flag' records where the color is either red OR green AND the quantity is greater than 10. The core of the formula is the logical test inside the IF function, which looks like...
In the example shown, we simply want to 'mark' or 'flag' rows where the color is 'red' AND size is either 'small' or 'medium'. To return TRUE when items are red and small, we can use a logical statement constructed with...
The goal of this example is to verify input before calculating a result. The key point to understand is that any valid formula can be substituted. The SUM function is used only as an example. The logic can also be...
When conditional formatting is applied with a formula, the formula is evaluated relative to the active cell in the selection at the time the rule is created. In this case, the active cell when the rule is created is...
The behavior of the IF function can be easily extended by adding logical functions like AND, and OR, to the logical test. If you want to reverse existing logic, you can use the NOT function.In the example shown, we...
Excel With C#
Note: this is a great example of a formula that is hard to understand because the cell references are hard to interpret. The gist of the logic used is this: if the time in row 4 is between the start and end times, the...
- FREE to access (no sign-up needed)
- 12+ hours of online training
- 26 Lessons
- Includes all example files downloads
Excel With Wayne
- FREE to access (no sign-up needed)
- 14+ hours of online training
- 21 video lessons (on YouTube)
- Includes all example files downloads
- FREE to access (no sign-up needed)
- 10+ hours of online training
- 36 video lessons
- Includes all example files downloads
- FREE to access (no sign-up needed)
- 6+ hours of online training
- 41 video lessons
- Includes all example files downloads
I create tons of free Excel Tips videos. Click below to join my YouTube channel and get instant access to 350+ videos
Join 110,000+ subscribers in getting weekly Excel tips videos