-
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
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
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.
The conditions are rules based on specified numerical values, matching text, calendar dates, or duplicated and unique values.
Here is the Highlight Cell Rules part of the conditional formatting menu:
Appearance Options
The web browser version of Excel offers the following appearance options for conditionally formatted cells:
Here is how the options look in a spreadsheet:
Cell Rule Types
Excel offers the following cell rule types:
Highlight Cell Rule Example
The "Equal To..." Highlight Cell Rule will highlight a cell with one of the appearance options based on the cell value being equal to your specified value.
The specified value could be a particular number or particular text.
In this example, the specified value will be "48".
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 all of the different stat values.
"Equal To..." Hightlight Cell Rule, step by step:
C2:H8 for all of the stat values
in the ribbon, from Home menu
This will open a dialog box where you can specify the value and the appearance option.
48 into the input field
Now, the cells with values equal to "48" will be highlighted in yellow:
All of Ditto's stat values are 48, so they 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}`) }) }