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

I have a table something like this:

text1A | text2A | value1A | text3A | value2A
text1B | text2B | value1B | text3B | value2B
text1C | text2C | value1C | text3C | value2C

If the value in column 3 is larger than the previous value, I would like the whole row to have a bottom border.

If the value in column 3 is smaller than the previous value, I would like the whole row to have a bold bottom border.

If the value in column 3 is equal, do nothing.

Anyone know how to do this with Excel conditional formating?

Thanks in advance.

share|improve this question

You can use relative references in Conditional Formatting conditions.

  1. Highlight the whole table.
  2. Click Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format
  3. Under Format values where this formula is true, type =$C1<$C2
  4. Click Format > Border. Set the bottom border, then click OK.
  5. Click Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format
  6. Under Format values where this formula is true, type =$C2<$C1
  7. Click Format > Font > Font Style = Bold. Then click OK.
share|improve this answer

You must log in to answer this question.

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