Hi Hui
The above code does show the cell color has not changed. However I am trying to get the Conditional Formatted Color. This color resides at the following.
a variable Rng.FormatConditions.Item 1.Interior.Color ---- etc... The problem is the Item 1 in the formatted conditions I cannot...
Does conditional formating change the color index of the cell, if not what does it do? I am trying to count the colored cells of the top 10 numbers in a list that can actually be 10 to 14 numbers.
Thanks
RalphJ