Is it possible to determine the number of cells in a column who contain a particular format? For instance, I have formatted every cell in a particular column to be highlighted in red if its value also appears in another column. After this formula is executed i'm left with a ton of cells that have been highlighted. Is it possible to count how many are highlighted without doing it one by one?
-
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.
Counting cells in a column based on format?
- Thread starter djroppolo
- Start date
Von Pookie
MrExcel MVP
- Joined
- Feb 17, 2002
- Messages
- 13,686
You can't count by color without a macro--so why not just count by the same criteria you're using to color?
This seems to work for me:
B1:B10 has conditional formatting to highlight the cells that have the same value as a cell in A1:A10 (the HTML Maker doesn't show conditional formats, the highlighting was added by me).
The formula in D2 does the same thing, except it displays the result instead of highlighting.
This seems to work for me:
| Book1 | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | 1 | 5 | ||||
| 2 | 2 | 15 | 5 | |||
| 3 | 3 | 365 | ||||
| 4 | 4 | 57 | ||||
| 5 | 5 | 8 | ||||
| 6 | 6 | 26 | ||||
| 7 | 7 | 1 | ||||
| 8 | 8 | 77 | ||||
| 9 | 9 | 5 | ||||
| 10 | 10 | 9 | ||||
Sheet2 | ||||||
B1:B10 has conditional formatting to highlight the cells that have the same value as a cell in A1:A10 (the HTML Maker doesn't show conditional formats, the highlighting was added by me).
The formula in D2 does the same thing, except it displays the result instead of highlighting.
Upvote
0
Similar threads
- Question
- Question
