Hi
I'm not sure if it is possible to reference named ranges when entering the formulas into the conditional formatting.
I have attached a file with the named range and show the expected results below it.
Basically I have a horizontal named range of cells with values (cells F8, G8, H8, ...)
When any of the cells vertically below it have the same value as the cell above it in the named range I want it to have a color.
I realize I don't have to use a named range but I would prefer to if it is possible.
Mark
Bookmarks