| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count the number of cells highlighted using Conditional Formatting feature present in Format Menu of Excel???
I have used Conditional Formatting present in the Format Menu to
highlight cells in the worksheet with satisfy the condition. Now I want to count the total number of cells highlighted by conditional formattin for each column and display in a cell of the column... Kindly help me with a way to do this...I tried using the interior.colorindex property to count the cells coloured ... but no use because conditional formattin doesnot actually change the cell's formatting it just highlight... Plzzz let me kno how to do.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count cells that are highlighted by conditional formatting | Excel Worksheet Functions | |||
| how to count number of highlighted cells in column | Excel Discussion (Misc queries) | |||
| Excel should return feature of highlighted cells as totals | Excel Worksheet Functions | |||
| Count number of cells that are highlighted | Excel Programming | |||
| Is there a way to count the number of highlighted cells in a col? | Excel Discussion (Misc queries) | |||
Threaded Mode
