Microsoft Office Tutorials and References
In Depth Information
Conditional formatting formula examples
FIGURE 19.23
Highlighting a row, based on a matching name
The conditional formatting formula is:
=$A3=$B$1
Notice that a mixed reference is used for cell A3. Because the column part of the reference
is absolute, the comparison is always done using the contents of column A.
Displaying alternate-row shading
The conditional formatting formula that follows was applied to the range A1:D18, as shown
in Figure 19.24, to apply shading to alternate rows.
=MOD(ROW(),2)=0
Search JabSto ::




Custom Search