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).

Hi could you please post a sample sheet ? Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Please see attached spreadsheet with notations. Thanks in advance for your help.

Attached Files

Conditional Formatting Example.xlsx (10.2 KB, 17 views)

I was able to solve my problem. See the attached spreadsheet. Go to the tab 'Problem Solved'.

The first part was accomplished by simply using the "Use Formula" option in the Conditional Formatting function.

The second part was accomplished by setting up a Named Range and then testing against that in the Conditional Formatting "Use Formula" function.

Thanks to anyone who was working on this for me.

Steve

Attached Files

Conditional Formatting Example.xlsx (16.1 KB, 12 views)