CODEWITHSUNDEEP
excelformatconditional-statementshighlight
sherrellbc
sherrellbc

Reputation: 4853

Excel 2007: conditional formatting for certain cells?

What I need to do is conditionally format the below cells to highlight the lowest value.

B2, H2, G2, M2, R2, W2, AB2, AG2, AL2

But I need to do this about 50 times, and again for another set but for the next field(B3, H3 .. etc) Is there any easier way to do this?

Upvotes: 0

Views: 358

Answers (1)

Dave Sexton
Dave Sexton

Reputation: 11188

Here is what you need to do:

Click on B2

Control click H2, G2 etc

Enter a conditional format based on a formula and use the following formula:

=B2=MIN($B2, $H2, $G2, $M2, $R2, $W2, $AB2, $AG2, $AL2)

Copy any one of these cells and paste special format only into any other cell where you want it applied.

Upvotes: 3

Related Questions