You'll need to highlight all of the cells that are included in the condition
when you define the conditional formatting.   You may need to add or remove $
from the cell locations to make sure it works properly.