Yes, very much possible. But since the conditional format, and formulas could work differently depending on its referencing, it will be better if you post a sample file that resembles the scenario / situation in your original file.