Copying Conditional formatting with relative cell referencces in the formula desn't work

Hi Rob,

Quote or not quote matter - in first case you compare two strings which are always the same, thus you always have same TRUE or same FALSE, depends on which texts to compare. In second case you compare values of the cells, result depends on how you use absolute and relative references.

You may use rule like this

You may use the rule not to entire range but for the first cell in it and after that copy formatting by format painter

In this case you generate as many similar rules as many cells in your range.

Sample attached.