HTML tutorial
CSS3 tutorial
Bootstrap tutorial
JavaScript tutorial
JQuery tutorial
AngularJS tutorial
React tutorial
NodeJS tutorial
PHP tutorial
Python tutorial
Python3 tutorial
Django tutorial
Linux tutorial
Docker tutorial
Ruby tutorial
Java tutorial
C tutorial
C ++ tutorial
Perl tutorial
JSP tutorial
Lua tutorial
Scala tutorial
Go tutorial
ASP.NET tutorial
C # tutorial
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 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:
The "Text That Contains..." Highlight Cell Rule will highlight a cell with one of the appearance options based on a part of the cell value containing your specified value.
The specified value is typically text, but also works with a numerical value.
In this example, the specified value will be "Pidge".
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 Name values.
"Text That Contains..." Hightlight Cell Rule, step by step:
A2:A8
for the Name valuesThis will open a dialog box where you can specify the value and the appearance option.
Pidge
into the input fieldNow, the cells with values Text That Contains "Pidge" will be highlighted in yellow:
The names "Pidgey", "Pidgeot", and "Pidgeotto" all start with "Pidge", so all these cells are highlighted.
Note: The Text That Contains rule works with any part of the cell values.
Like in the example below:
The "Text That Contains..." Highlight Cell Rule will highlight a cell with one of the appearance options based on a part of the cell value containing your specified value.
The specified value is typically text, but also works with a numerical value.
In this example, the specified value will be "row".
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 Name values.
"Text That Contains..." Hightlight Cell Rule, step by step:
A2:A8
for the Name valuesThis will open a dialog box where you can specify the value and the appearance option.
row
into the input fieldNow, the cells with values Text That Contains "row" will be highlighted in yellow:
The names "Spearow" and "Fearow" both end with "row", so both cells are highlighted.
Note: You can remove the Highlight Cell Rules with Manage Rules.
The "Text That Contains..." Highlight Cell Rule also works with numbers.
In this example, the specified text value will be "7".
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 the different stat values.
"Text That Contains..." Hightlight Cell Rule, step by step:
C2:H8
for all the stat valuesThis will open a dialog box where you can specify the value and the appearance option.
7
into the input fieldNow, the cells with values That Contains "7" anywhere will be highlighted in green:
Note: The Text That Contains... Highlight Cell Rule will highlight cells that have values with any part matching the specified value.
You can use the Equal To... rule for highlighting cells that exactly matches the specified value.
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}`) }) }