Highlight Microsoft Excel rows

1129475 pts.
Tags:
Microsoft Excel
Would I be able to have Microsoft Excel highlight rows by their row number? I need several specific rows highlighted for a client. Thanks for the help.
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Do you want this to be automatic? If so you can do it by formatting the cell(s) based on a condition. 

  1. Select Conditional Formatting
  2. Select New Rule
  3. Select “Use a Formula to determine which cells to format”
  4. Enter the Formula, =INDIRECT(“g”&ROW())=”X”
  5. Enter the Format you want (text color, fill color, etc).
  6. Select OK to save the new format
  7. Open “Manage Rules” in Conditional Formatting
  8. Select “This Worksheet” if you can’t see your new rule.
  9. In the “Applies to” box of your new rule, enter =$A$1:$Z$1500 (or however wide/long you want the conditional formatting to extend depending on your worksheet)

For every row in the G column that has an X, it will now turn to the format you specified. If there isn’t an X in the column, the row won’t be formatted.

You can repeat this to do multiple row formatting depending on a column value. Just change either the “g” column or “x” specific text in the formula and set different formats.

For example, if you add a new rule with the formula, =INDIRECT(“h”&ROW())=”CAR”, then it will format every row that has “CAR” in the H Column as the format you specified.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: