Leading the way in Microsoft Office Development

All of these formulas can be entered directly as a formula where cell "A1" is the top left cell in your range of cells.

Shading Alternate Rows

=MOD(ROW(),2)=0

Find Today's Date

A1=TODAY()

Dates Within a Period

Find Current Month

=MONTH(A1)=MONTH(TODAY())

Shade any Blank Cells

=ISBLANK(A1)

Largest Value

=MAX($A$1:$B$10)

assuming your cell range is "A1:B10"

Two Smallest Values

=A1>=SMALL($A$1:$B$10,2)

assuming your cell range is "A1:B10"

Non Numeric Cells

=ISTEXT(A1)

Below Average

Identifies all the cells which are below average.

=A1>AVERAGE($A$1:$B$10)

assuming your cell range is "A1:B10"

Cells Containing Spaces

=LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))>0

Cells Containing a Particular Character

=LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,"R",""))>0

Matching Text

=A1="text_to_match"

You can apply conditional formatting to check the value in one cell and apply formatting to other cells. Just reference the cells (e.g. ).