Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional formatting--different formatting depending on cell con | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions |