Thanks gebobs. I'm actually looking to do it via conditional formatting so that I can record it in a macro and input different lists in the cells. I have found that I have to clear rules and run a new format every time, or else it won't revert formatting when I run the macro. I know it is possible to do because I have seen a former coworker do it, I just don't know he did it.