D
divya
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..
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..