T

#### Thomas M.

I have an 8 x 8 grid in which I want to flag all cells that are not evenly

divisible by .5. I can do this for a single cell with the following formula

as the conditional formatting criteria:

=MOD($R$8,0.5)>0

The obvious drawback is that this formula refers to the specific cell, so to

set it up in an 8 x 8 grid would require 64 separate conditional formatting

rules. There's got to be a better way.

Is it possible to create one conditional formatting rule which uses a

formula for the conditional formatting criteria, can be applied to a range,

and acts upon each cell in the range separately and not on the range as a

whole?

--Tom