Microsoft Office Tutorials and References
In Depth Information
Conditional formatting formula examples
Highlighting a row, based on a matching name
The conditional formatting formula is:
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.