Highlight cells rules
Text that contains
A date occuring ...
Top bottom rules
Top 10 items
Top 10 %
Overview - CF formulas
Highlight empty cells
Highlight text values
Numbers in range
Highlight lookup values
Records [AND logic]
Records contain [AND]
Records [OR logic]
Based on a column
Based on a cell range
Filtered Excel table
Based on cell range
Based on date
Date, week, month
Min duplicate number
Two columns (common)
Two cols (difference)
Missing values (2 cols)
Two price lists
Based on month
Based on day of week
Overlapping date rngs
Overlap rngs - condition
Highlight current date
Every other row
Based on coordinates
Weekly Blog EMAIL
Get a FREE PDF book!
Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Data bars allows you to insert a data bar into each cell in the selection, the size is based on the cell value. The biggest data bar corresponds to the largest value in selection.
If you want to change data bars settings for an existing cell range follow these steps:
To create new data bars and also edit settings before creation then follow these steps:
The data bar settings dialog box appears.
This dialog box lets you format the data bars and how the minimum and maximum values are calculated. You can also hide the values so only the data bars are visible.
I prefer having the values next to the data bars, simply copy the values and paste to the next column then apply the data bars with values hidden.
How to create color scales [Conditional Formatting]
Color scales in conditional formatting applies a color to cells in a cell range based on their values, this lets you […]
How to insert icons representing cell values [Conditional formatting]
Conditional formatting lets you insert icons based on cell values, the idea is to make the data easier to read, […]
Highlight overlapping date ranges using conditional formatting
The image above demonstrates a conditional formatting formula that colors a record if there is at least one record that […]
Highlight records based on overlapping date ranges and a condition
adam asks: Hi, I have a situation where I want to count if this value is duplicate and if it […]
Highlight dates in a date range
Question: How do I highlight dates that meet criteria using conditional formatting? Table of contents Highlight values in a column […]
Highlight closest number
This post demonstrates how to highlight records with the closest value to a criterion, you can also choose to highlight […]
Highlight duplicate records
This blog post shows you how to easily identify duplicate rows or records in a list. Conditional formatting formula: =COUNTIFS($B$3:$B$15, […]
How to highlight MAX and MIN value based on month
The image above shows rows highlighted based on value in column C being the largest or smallest in that particular […]
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 […]
Question: I have a list that I keep adding rows to. How do i create a border that expands as […]
Highlight records – multiple criteria [OR logic]
The image above shows you how to highlight rows with multiple criteria using OR logic. The criteria are found in […]
Highlight duplicates in a filtered Excel Table
The image above demonstrates a conditional formatting formula applied to an Excel Table containing random data. The Excel Table has […]
Leave a Comment
Mail (will not be published) (required)
Notify me of followup comments via e-mail
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
You can contact me through this contact form