Possible Duplicate:
Excel 2010 conditional formatting: selectively highlighting duplicates
I have dates that are running off a formula in that column based on information it's collecting from other worksheets. I have another column that lists text answers based on a different formula that that column is running.
It is a customer list that runs with names going down page and multiple columns of information for each client running across page
What I want to do is:
If column J says paid then turn column M - same row - a color or border or something.
I will repeat this formula for the various things that J can say, I just can't figure out how to make conditional formatting read J to change M.
To complicate things, in addition to the formula running to collect the date in column M, there is also a conditional format set up for M that changes the color of the cells after a certain date. I want to be able to keep that formula, in addition to the one that you are assisting with. I will use highlighting, or something different to avoid any conflicts.
1 Answer
- Select column M. Check which cell is highlighted (let's assume M1)
- Conditional Formatting \ New Rule
- Use a formula to determine which cells to format
- Type in the following formula
=J1="paid"(using the highlighted cell's row number - remember M1) - Choose your formatting, then validate.
- Repeat as needed for the other conditions and formats.
- for your other condition (see comment)
=and(or(j1="renew",j1="-"),M1>=today()+1)
