Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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:


Replace it with your conditional:


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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .