I am working with a set of analyzed values in one tab that have a numerical index ranking in a separate tab. Based on whether the numerical index ranking for the analyzed data is above or below a critical limit, I need to set up some conditional formatting that tells me if the analyzed value is valid (again, based on the numerical index ranking in the other tab). For example, if the numerical index ranking for the analyzed value is above a certain limit, then the analyzed value is automatically formatted in some color or font that readily identifies the value as "bad". I am pretty sure conditional formatting can help me, but I am not sure where to start. Any help on this would be appreciated.