Highlight cells based on coordinates
The picture above shows Conditional Formatting highlighting cells in cell range F3:Y22 based on row and column values in column B […]
Pamela asks: I would like to ask you how to identify PAIR of same numbers, but with a different sign. […]
The conditional formatting formula applied to cell range B3:F15 highlights all blank cells yellow. Here is how I did it:
Compare two columns and highlight differences
A conditional formatting formula highlights values that only exist in one column. Example, BB and GG exist only in column […]
Sankalp asks: I am working in a railway project as planner. How can i create a dynamic strip chart in […]
Highlight unique values in a filtered excel table
Conditional Formatting has some amazing built-in features, for example it lets you highlight unique values in a list without entering a […]
Counting conditionally formatted cells (vba)
UPDATE: It is not possible to count conditionally formatted cells using vba as far as I know, I recommend you […]
Highlight date ranges overlapping selected record [VBA]
The following example shows you how to highlight overlapping ranges. How it works Select a date in the table. Conditional […]
Highlight duplicates in a filtered Excel defined table
You can highlight duplicates in an excel defined table using conditional formatting. However, that won´t work if you only want […]
Drop down list changes cell formatting
You can apply different conditional formatting formulas and formatting to a cell range, using a drop down list. Here is […]
Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]
Highlight numbers within specific ranges
Merit asks: I have a large array of numbers and a row of numbers. I want each number in the […]
Working with Conditional Formatting formulas
In this post I am going to try to explain formula basics in conditional formatting. It is really good if […]
I would like to show you how to search a table using conditional formatting. The criteria highlight matching column and […]
How to highlight differences in price lists
Today I am going to show you how to quickly compare two tables using Conditional Formatting (CF). I am going […]
This blog post shows you how to create a conditional formatting formula and highlight matching records. You can easily change […]
Highlight records – multiple criteria [OR logic]
This blog post shows you how to highlight rows with multiple criteria using OR logic. The criteria is found in […]
This post decribes how to highlight records with closest value to a criterion. You can also choose to highlight the […]
This article describes how to highlight duplicate records and filter duplicate records. There is one record in each column, cell […]
This blog post shows you how to easily identify duplicate rows or records in a list. Conditional formatting formula: =COUNTIFS($B$3:$B$15, […]
Highlight duplicates with same date, week or month
Highlight duplicates on the same date Conditional formatting formula: =SUMPRODUCT(--($C3&"-"&$D3=$C3:$C$3&"-"&$D3:$D$3))>1 Highlight duplicates on same week Conditional formatting formula: =SUMPRODUCT(--($B16&"-"&YEAR($C16)&"-"&$D16=$B16:$B$16&"-"&YEAR($C16:$C$16)&"-"&$D16:$D$16))>1 Highlight […]
Color odd months Conditional formatting formula: =MOD(MONTH($B6),2) Color even months Conditional formatting formula: =NOT(MOD(MONTH($B6),2)) Color odd years Conditional formatting formula: […]
Highlight duplicates based on criteria, part 2
This blog article is one out of two articles on the same subject. Highlight duplicates where adjacent cell value meets […]
How to highlight MAX and MIN value based on month
Conditional formatting formula to highlight max value in every month: =B2=MAX(IF(MONTH(A2)=MONTH(Date_rng), Close, "")) Conditional formatting formula to highlight min value […]
Highlight more than once taken course in any given day
Question: My scenario is tracking employees who complete online training. I capture their name, id, class taken, and date. Any […]
Highlight unique distinct values in two cell ranges
Conditional formatting formula in B2:E5: =IF(ROW(B2)>MIN(ROW(tbl)), COUNTIF(OFFSET(tbl, 0, 0, MIN(ROW(B2)-MIN(ROW(tbl))), MAX(COLUMN(tbl))), B2)+COUNTIF(OFFSET(tbl, MIN(ROW(B2)-MIN(ROW(tbl))), 0, 1, MIN(COLUMN(B2))), B2), COUNTIF(OFFSET(tbl, 0, 0, […]
Highlight duplicate values in two cell ranges combined
Question: How do I highlight duplicate values in two ranges combined? Answer: Range 1, A1:D4, named tbl Range 2, A6:D9, […]
Highlight smallest duplicate number
Question: How do I highlight the smallest duplicate value in a column using conditional formatting? Answer: Conditional formatting formula in […]
Highlight duplicate values in a cell range
Question: How do I highlight duplicate values in a range (A1:D4) using conditional formatting? Answer: Conditional formatting formula: =IF(ROW(G5)>MIN(ROW(tbl)), COUNTIF(OFFSET(tbl, […]
Highlight unique values and unique distinct values in a cell range
Highlighting unique distinct values in a range using conditional formatting Repeated values are not highlighted, only unique distinct values. Conditional […]
Highlight duplicates in two columns
Question: I need to delete duplicates in two different columns together. How do I highlight the second or more duplicates […]
Compare two columns and highlight values in common
A conditional formatting formula highlights values in column B that also exist in column D. =COUNTIF($D$3:$D$7,B3) The same thing happens […]
Question: I have a list that I keep adding rows to. How do i create a border that expands as […]
Highlight missing values between to columns
The picture above shows two lists. How do I highlight values in List 1 that are not in List 2? […]
How to highlight duplicate values
The picture above shows duplicate values in column B, only the second or more duplicates are colored and easily identified. […]
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 […]
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 duplicates based on criteria, part 1
Conditional formatting formula: =IF($A2=$E$1, COUNTIFS($A$2:$A$16, $E$1, $B$2:$B$16, $B2), 0) How to apply the conditional formatting formula in excel 2007: Select […]
How to highlight unique distinct values
You may have tried to create a unique distinct list, using conditional formatting with excel 2007, merging duplicates into one […]
Welcome! I am 