Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count if cell is highlighted
I have Excel 2007 and I do not know how to count yellow highlighted cells
within a column. I saw a response to this question but it was for Excel 2003 and the answer included using VB. I do not know how to use VB. Is there an easier way? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count if cell is highlighted
Is there an easier way?
Yes. Write a formula based on the logic of *why* the cells are shaded yellow. -- Biff Microsoft Excel MVP "Sherree Gorman" wrote in message ... I have Excel 2007 and I do not know how to count yellow highlighted cells within a column. I saw a response to this question but it was for Excel 2003 and the answer included using VB. I do not know how to use VB. Is there an easier way? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count if cell is highlighted
Why are the cells colored yellow?
If by Conditional Formatting, use the same criterion to count the cells. If manually colored you have to use VBA or this method below. For 2003 I would do an EditFind for the Format yellow and Find All. Hit CTRL + a to select all in the "Found" dialog then on Status Bar select "Count" Gord Dibben MS Excel MVP On Fri, 26 Dec 2008 19:14:01 -0800, Sherree Gorman wrote: I have Excel 2007 and I do not know how to count yellow highlighted cells within a column. I saw a response to this question but it was for Excel 2003 and the answer included using VB. I do not know how to use VB. Is there an easier way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNT HIGHLIGHTED CELLS IN A ROW ? | Excel Discussion (Misc queries) | |||
Highlighted Columns Count! | Excel Discussion (Misc queries) | |||
Count Highlighted Rows | Excel Discussion (Misc queries) | |||
count highlighted cells | Excel Discussion (Misc queries) | |||
Count highlighted cells | Excel Worksheet Functions |