#1
|
|||
|
|||
Conditional Formatting based on Value of Another Cell
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). Last edited by SteveBump; 03-07-2014 at 08:34 AM. Reason: Solved part of the problem |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
Please see attached spreadsheet with notations. Thanks in advance for your help.
|
#4
|
|||
|
|||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting value change of same cell | tcalhoun | Excel | 0 | 04-25-2013 07:25 AM |
Conditional formatting question based on cell date | Cosmo | Excel | 2 | 04-08-2013 12:12 PM |
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell | Frogggg | Excel | 1 | 10-25-2011 08:44 PM |
How can I fill cell color starting from Cell D5 using Conditional formatting instead | Learner7 | Excel | 0 | 07-08-2010 05:50 AM |
Conditional formatting of cell, Excel 2003 | Scaffold | Excel | 2 | 05-01-2010 08:56 AM |