Excel Course: Custom Conditional Formatting
For this example, the name of a month has been entered into cell B8.
The goal here is to create a CF that can automatically shade the column in the table for the month whose name appears in B8.
Select all the cells in the table and choose "New Rule...":
Choose the last kind of rule to enter a formula.
Begin your formula with an
= sign, then enter the first cell to test (in this case, B1) and finally enter
=$B$8 (with the
$ sign to "fix" the cell reference).
=B1=$B$8, the CF will be applied to every cell that contains the search value (in this case, February).
=B1=$B$8 is for the first cell in the table, and will be modified for the other cells (as in a Fill Series command).
This table should help you better understand the test that is being performed on each cell:
To format the entire column, rather than just a single cell, we will have to "fix" the row number using a
To edit the formula, click on "Manage Rules..." then "Edit the Rule...".
$ before the row number.
This time, the whole column has been formatted.
The tests performed on the cells:
To format a whole column, now all we have to do is change the month that appears in cell B8.