Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

We create sections by highlighting an area in Excel 2010 and clicking ALL BORDERS. We want to set it so that any time you type "REPLA" between columns J and Q, the line that "REPLA" is in will Fill Color to YELLOW, but ONLY the line within the Bordered area (between J and Q).

Also will need two other words that become other colors.

share|improve this question

1 Answer 1

You can use this tutorial on conditional formatting to build a solution for your needs: Automatically Highlight Max Value in a Data Table Using Conditional Formatting

Instead of using the formula:

=$G4=MAX($G:$G)

Replace it with your conditional:

=$G4="REPLA"

Note that the specified range in your case will also be changing to J:Q, etc.

share|improve this answer
    
Thanks ChrisF! Unfortunately I seem to suck at this and haven't been able to figure it out, even with your answer. Is there any way you could be more specific in what I need to do? I'm sure you're crazy busy, but it would help me out ALOT!!! –  Shawn Dec 20 '13 at 14:44
    
Please be specific about what you are struggling with and what you have questions about... Otherwise it is difficult to give assistance. –  Excel Tactics Dec 21 '13 at 17:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.