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.

I'd like a single conditional format rule I can apply to a range (a columns) so that a number appears in bold if it is greater that the number to its left, like this:

100 200
200 190
200 300

Is there any way to do this without defining a conditional format for each cell?

share|improve this question
add comment

2 Answers

You can select the whole range at once and define the conditional format using a formula. For example if the data is in columns A and B, select the cells in column B, starting with B2 (if B1 has labels). Then create a conditional format with the formula

=B2>A2

If you click the cells, they will turn up as absolute references, with $ signs, which you need to remove. It might be easier to just type the cell references.

Then set a format.

In Excel 2007 and later you can also use this technique: apply the conditional format to just one cell. Instead of copying and pasting with format only, you can use the command to manage conditional formatting from the ribbon drop-down. In the management panel you can set the range that the format should be applied to. The screenshot shows that dialog before OK is clicked, so in the sheet, the format currently only applies to the selected cell.

enter image description here

share|improve this answer
add comment

Try this. Set the conditional format on the first cell, making sure to use a relative address for the value to compare with (remove the $ symbols in the cell reference).

Then, COPY the cell and use EDIT > PASTE SPECIAL > FORMATS to paste the conditional format to the remaining cells.

share|improve this answer
add comment

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.