Search notes:
Excel: Home -> Styles -> Conditional Formatting -> New Rule
Rule types that can be selected:
Format all cells based on their values
Format only cells that contain
Format only top or bottom ranked values
Format only values that are obove or below average
Format only unique or duplicate values
use a
formula
to determine which cells to format
Index