This is conditional formating. Each cell is independantly given this
conditional formating. You have 25 rows (rows 2 to 26) and 9 (T to AB)
columns, Therefore the condtion is being placed in 225 cells on each
worksheet.

There can only be three different condtional formating in each cell so I
don't know how you are getting 10.



" wrote:

The only possible values for the selected cells are a 1 or a 0. The
problem isn't that the conditional formatting is giving false
positives. My problem is that the visual basic applies 10 versions of
the same conditional formatting to each cell.