Hey everyone! I'm trying to run VBA code or use a formula to have a cell highlighted (one of 9 columns) if that cell's value matches the value in a 10th column. So, 9 columns with different numbers in each, and going line by line, those numbers would need to be compared to the value in the 10th column, and the cell in that row that matches the 10th column value would be highlighted. Is this possible with VBA or a formula? Conditional formatting didn't seem to let me do it for that many cells. I appreciate y'all's help!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting for Multiple Columns
- Thread starter jruss
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 90,535
- Office Version
- 365
- Platform
- Windows
Conditional Formatting will do that.
In this example, select A1:I15 & use the formula
=A1=$J1
| Excel 2013/2016 | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | |||
| 1 | 8 | 6 | 6 | 3 | 4 | 8 | 1 | 8 | 9 | 8 | ||
| 2 | 1 | 5 | 9 | 8 | 4 | 10 | 9 | 1 | 10 | 4 | ||
| 3 | 6 | 8 | 1 | 6 | 5 | 3 | 7 | 7 | 3 | 3 | ||
| 4 | 9 | 9 | 6 | 10 | 10 | 3 | 7 | 10 | 3 | 6 | ||
| 5 | 2 | 10 | 7 | 1 | 6 | 2 | 2 | 8 | 3 | 1 | ||
| 6 | 3 | 4 | 4 | 10 | 10 | 5 | 3 | 2 | 2 | 7 | ||
| 7 | 5 | 5 | 8 | 4 | 7 | 3 | 2 | 6 | 1 | 5 | ||
| 8 | 10 | 3 | 8 | 4 | 3 | 10 | 7 | 7 | 5 | 1 | ||
| 9 | 6 | 7 | 10 | 9 | 1 | 6 | 10 | 5 | 7 | 6 | ||
| 10 | 6 | 5 | 4 | 5 | 3 | 1 | 3 | 10 | 1 | 4 | ||
| 11 | 4 | 5 | 2 | 5 | 3 | 7 | 6 | 2 | 10 | 7 | ||
| 12 | 6 | 4 | 2 | 8 | 5 | 8 | 6 | 9 | 1 | 3 | ||
| 13 | 1 | 2 | 4 | 2 | 1 | 6 | 7 | 6 | 9 | 1 | ||
| 14 | 2 | 7 | 5 | 4 | 2 | 8 | 10 | 6 | 1 | 8 | ||
| 15 | 5 | 5 | 5 | 3 | 4 | 1 | 6 | 2 | 10 | 1 | ||
Sheet1 | ||||||||||||
In this example, select A1:I15 & use the formula
=A1=$J1
Upvote
0
Similar threads
- Question
