Conditional formatting works against the cell's own value OR with formulas to look at other cell's. Both are doable.

You can try it either way, or post a sample and show us what you want to happen and we can help.