View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thomas M. Thomas M. is offline
external usenet poster
 
Posts: 68
Default Conditional Cell Formatting

Excel 2007

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