Archive for the ‘Conditional formatting’ Category
Sankalp asks: I am working in a railway project as planner. How can i create a dynamic strip chart in […]
Comments(0) Filed in categories: Conditional formatting, Excel
You can group rows or columns manually using the "Group" feature. That will tie a range of cells together so […]
Comments(0) Filed in categories: Built-in features, Conditional formatting, Excel, Sort values
Conditional Formatting has some amazing built-in features, for example it lets you highlight unique values in a list without entering a […]
Comments(0) Filed in categories: Conditional formatting, Excel
UPDATE: It is not possible to count conditionally formatted cells using vba as far as I know, I recommend you […]
Comments(26) Filed in categories: Conditional formatting, Count values, Excel, User defined functions (udf), VBA
The following example shows you how to highlight overlapping ranges. How it works Select a date in the table. Conditional […]
Comments(2) Filed in categories: Conditional formatting, Excel, Overlapping, VBA
You can highlight duplicates in an excel defined table using conditional formatting. However, that won´t work if you only want […]
Comments(4) Filed in categories: Conditional formatting, Excel, Excel table
You can apply different conditional formatting formulas and formatting to a cell range, using a drop down list. Here is […]
Comments(3) Filed in categories: Conditional formatting, Drop down lists, Excel
Geoff asks: Hi Oscar, I have a cross reference table we use for shift scheduling. The x-axis is comprised of […]
Comments(5) Filed in categories: Conditional formatting, Cross reference table, Excel, Schedule, Templates
Merit asks: I have a large array of numbers and a row of numbers. I want each number in the […]
Comments(1) Filed in categories: Conditional formatting, Excel
In this post I am going to try to explain formula basics in conditional formatting. It is really good if […]
Comments(3) Filed in categories: Conditional formatting, Excel
I would like to show you how to search a table using conditional formatting. The criteria highlight matching column and […]
Comments(4) Filed in categories: Conditional formatting, Excel
I have noticed when I apply conditional formatting on larger cell ranges, file size increases rapidly. This post demonstrates how […]
Comments(0) Filed in categories: Conditional formatting, Excel, VBA
Today I am going to show you how to quickly compare two tables using conditional formatting. We are comparing two […]
Comments(2) Filed in categories: Compare, Conditional formatting, Excel
This blog post shows you how to create a conditional formatting formula and highlight matching records. You can easily change […]
Comments(0) Filed in categories: Conditional formatting, Excel, Records
This blog post shows you how to highlight rows with multiple criteria using OR logic. The criteria is found in […]
Comments(3) Filed in categories: Conditional formatting, Excel, Records
This post decribes how to highlight records with closest value to a criterion. You can also choose to highlight the […]
Comments(10) Filed in categories: Conditional formatting, Excel
This article describes how to highlight duplicate records and filter duplicate records. There is one record in each column, cell […]
Comments(0) Filed in categories: Conditional formatting, Excel, Records
Highlight duplicates on 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 duplicates […]
Comments(0) Filed in categories: Conditional formatting, Dates, Excel
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: […]
Comments(0) Filed in categories: Conditional formatting, Dates, Excel, Mod
This blog article is one out of two articles on the same subject. Highlight duplicates where adjacent cell value meets […]
Comments(0) Filed in categories: Conditional formatting, Excel
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 […]
Comments(7) Filed in categories: Conditional formatting, Dates, Excel
Question: My scenario is tracking employees who complete online training. I capture their name, id, class taken, and date. Any […]
Comments(0) Filed in categories: Conditional formatting, Excel
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, […]
Comments(1) Filed in categories: Compare, Conditional formatting, Excel, Unique distinct values
Question: How do I highlight duplicate values in two ranges combined? Answer: Range 1, A1:D4, named tbl Range 2, A6:D9, […]
Comments(1) Filed in categories: Compare, Conditional formatting, Excel
Question: How do I highlight the smallest duplicate value in a column using conditional formatting? Answer: Conditional formatting formula in […]
Comments(0) Filed in categories: Conditional formatting, Excel
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, […]
Comments(2) Filed in categories: Conditional formatting, Excel
Highlighting unique distinct values in a range using conditional formatting Repeated values are not highlighted, only unique distinct values. Conditional […]
Comments(1) Filed in categories: Conditional formatting, Excel, Unique distinct values, Unique values
Question: I need to delete duplicates in two different columns together. How do I highlight the second or more duplicates […]
Comments(0) Filed in categories: Excel, Highlight duplicates
Question: How do I highlight duplicates in two lists using conditional formatting? In other words, how do I highlight cell […]
Comments(0) Filed in categories: Conditional formatting, Excel
Question: I have a list that I keep adding rows to. How do i create a border that expands as […]
Comments(5) Filed in categories: Conditional formatting, Excel
To the right is a picture of an excel list. (B3:B11) The second or more duplicates are colored and are […]
Comments(1) Filed in categories: Conditional formatting, Excel
Question: How do I highlight dates that meet a criteria using conditional formatting? Table of contents Highlight values in a […]
Comments(15) Filed in categories: Conditional formatting, Excel
You may have tried to create a unique distinct list, using conditional formatting with excel 2007, merging duplicates into one […]
Comments(3) Filed in categories: Conditional formatting, Excel
