I have 30 or so rows of data each with about 23 numbers in them. Each cell
in that range has conditional formating in it to see if it is over a target
number. I now need excel to count how man of them are above goal. I am
using colorindex 5 and have some code that will count how many as long as I
just color the cell with the fill icon but for some reason it does not want
to do it when I use CF. I was trying to get away from CF and just write some
loop in a macro that will look to see if it is over goal and then color it
blue, then move on to the next stat but I am not sure that excel can do that.
Any ideas on how I can do this?