I love how SUMIF works in that it allows me to SUM the value in one cell based on the value in a corresponding cell in the same row. I'm trying to do something similar with Conditional Formatting.

Essentially, I have an entire column, "A", and I want to change the text for a specific cell to a different color if the value in the same row in column "C" is equal to a certain value. All my prior uses of Conditional Formatting only tested the value of the cell being formatted. In this case, I want to change it based on the value of another cell.

Lastly, if what I described above is possible, I would prefer to make the conditional test check if the value is equal to one of the values in a group that I would somehow define. Is there a way to test against a list without using a nested IF statement? I.e., If value in column C = One_of_my_list, then change the formatting in column A. And "One_of_my_list" contains Y2, Y3, Z1, Z2 and Z3.



Thanks.
Steve

P.S. I figured out how to accomplish what I requested in the last paragraph using a Named Range. However, I am still searching for a way to format one cell based on the value of another (that has no relational comparison to the cell being formatted).