I have a speadsheet with conditional format formulas that have both fixed ($A$1)and relative (A1) references. There are too many cells to change all the relative references to fixed as each cell would have to be changed indiviually. I have as many as 3 different conditional format formulas. I want to be able to count how many cells meet each conditional format (one is yellow fill, one is bold type and the last is double underline). Since I can't use the conditional format formula, since each cell's is different, I need to be able to count the cells in the range if the format is applied. Does anybody know how to do this? I have checked several forums that supposedly had answers, but none of them worked. Since I did not see a posting here, so I decided to post my questin in this forum rather than one of the others.