1. 1

    How do you create a custom conditional formatting rule? Select your range of data and…

  2. 2

    In a conditional formatting rule, how do you make a cell reference fully relative (instead of the default absolute reference)?

  3. 3

    If you set one conditional formatting rule to fill the cell background in orange if the value is over 1000, and a second rule to set the font color to red and bold if the value is over 2000, what will the cell formatting look like if the value is 2500?