2009 November

Get
Digital
Help

Home
Functions
Functions A to Z Functions by category
Formulas
Features
Excel Basics Excel Defined Table Advanced Filter Data Validation Drop-down lists Named Ranges Solver
Charts
Conditional formatting
Pivot table
VBA
VBA Functions Methods Properties Statements Macros User defined functions Files & folders Checkboxes
Archive
All articles
Contact
About me Blogs I read

Conditional formatting

Highlight cells rules

Text that contains

A date occuring ...

Unique/duplicates

Top bottom rules

Basic formulas

Overview - CF formulas

Highlight empty cells

Highlight text values

Numbers in range

Search

Highlight lookup values

Records [AND logic]

Records contain [AND]

Records [OR logic]

Unique distinct

Based on a column

Based on a cell range

Highlight records

Filtered Excel table

Duplicates

Based on a column

Based on cell range

Date, week, month

Duplicate columns

Min duplicate number

Filtered Excel table

Compare

Two columns (common)

Two cols (difference)

Missing values (2 cols)

Two price lists

Min max

Min duplicate number

Dates

Highlight weekends

Based on day of week

Overlapping date rngs

Overlap rngs - condition

Highlight current date

Odd/even months

Formatting

Misc

Every other row

Based on coordinates

Dynamic formatting

Opposite numbers

Drop-down selector

Highlight cells based on ranges

Archive for November, 2009

Search website