Excel Advanced

find blank cells

copy range with hidden cells

find specific format of cells

find nonblank cells

have a specific value

have a specific text

are blank

are nonblank

have errors

Data Bars

2-Color Scale

3-Color Scale

5-Color Scale

Icon Sets

a number

a text

a logical value (True/False)

cannot look left

cannot lookup 2 columns

cannot look both directions (rows and columns)

cannot find an approximate match

apply date functions

apply arithmetic operations

apply text functions

lower case

upper case

first letter of a word to lower and others to upper case

first letter of a word to upper and others to lower case

ISERROR treats #N/A as an error value

ISERR treats #N/A as an error value

ISERROR does not treats #REF! as an error value

ISERR does not treat #REF! as an error value

a text file

the web

a database

the PowerPoint

the SharePoint

on demand

on specific time (i.e. on 12:00 AM)

on file open

by time interval (i.e. by 60 min)