-
Excel Tutorial
- Excel HOME
- Excel Introduction
- Excel Get Started
- Excel Overview
- Excel Syntax
- Excel Ranges
- Excel Fill
- Excel Move Cells
- Excel Add Cells
- Excel Delete Cells
- Excel Undo Redo
- Excel Formulas
- Excel Relative Reference
- Excel Absolute Reference
- Excel Arithmetic Operators
- Excel Parentheses
- Excel Functions
Excel Formatting
- Excel Formatting
- Excel Format Painter
- Excel Format Colors
- Excel Format Fonts
- Excel Format Borders
- Excel Format Numbers
- Excel Format Grids
- Excel Format Settings
Excel Data Analysis
- Excel Sort
- Excel Filter
- Excel Tables
- Excel Conditional Format
- Excel Highlight Cell Rules
- Excel Top Bottom Rules
- Excel Data Bars
- Excel Color Scales
- Excel Icon Sets
- Excel Manage Rules (CF)
- Excel Charts
Table Pivot
Excel Case
Excel Functions
- AND
- AVERAGE
- AVERAGEIF
- AVERAGEIFS
- CONCAT
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- IF
- IFS
- LEFT
- LOWER
- MAX
- MEDIAN
- MIN
- MODE
- NPV
- OR
- RAND
- RIGHT
- STDEV.P
- STDEV.S
- SUM
- SUMIF
- SUMIFS
- TRIM
- VLOOKUP
- XOR
Excel How To
Guided Projects
- Introduction to Excel
- Learn Data Calculations
- Learn Data Visualization
- Learn to Create a Budget
- Learn to Create a Timeline
- Learn to Style in Excel
Excel Examples
Excel References
Excel Highlight Cell Rules - A Date Occurring
Highlight Cell Rules is a premade type of conditional formatting in Excel used to change the appearance of cells in a range based on your specified conditions
Highlight Cell Rules - A Date Occurring
Highlight Cell Rules is a premade type of conditional formatting in Excel used to change the appearance of cells in a range based on your specified conditions.
Here is the Highlight Cell Rules part of the conditional formatting menu:
Highlight Cell Rule - A Date Occurring Example
The "A Date Occurring..." Highlight Cell Rule will highlight a cell with one of the appearance options based on the cell value relative to a specified time frame.
The time frame can be:
In this example, the specified time frame will be "next month".
You can choose any range for where the Highlight Cell Rule should apply. It can be a a few cells, a single column, a single row, or a combination of multiple cells, rows and colums.
Let's apply the rule to the Birthday values.
"A Date Occurring..." Hightlight Cell Rule, step by step:
C2:C19 for the Birthday values
in the ribbon, from Home menu
This will open a dialog box where you can specify the value and the appearance option.
Now, the cells with values A Date Occurring next month will be highlighted in yellow:
Note: In this example, the next month happens to be September.
Turtwig, Chimchar, Piplup, Snivy, Tepig, and Oshawott all have birthdays in September, so their cells are hightlighted.
Note: You can remove the Highlight Cell Rules with Manage Rules.
function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Copied the text: ' + copyText.value) }) .catch((error) => { alert(`Copy failed! ${error}`) }) }