I have created a VB program that will check through out my spreadsheet for a
font that is a certain color. I am coloring my font's within the worksheet
using conditional formating. The problem I have is the conditional font color
does not seem to match up with the normal font color.

Example:
I am using a font.colorindex= 9 (Maroon) in my visual basic program.
I am choosing the "maroon" color font when doing my conditional formating in
the spreadsheet. (It does not allow you to give a color index number when
conditionally formating, you have to pick it from a color pallet.)

In my VB I am trying to count the cells that are "maroon" in color.

Here is what happens:
The cell that is colored due to the conditional formating is not counted.
If I manually format the font from the title bar, then the cell is counted.
It seems as though the conditional formating does not actually change the
font number and does not pick up in the count until I change the color
manually.

Any ideas on how to fix this?