maybe it's just a limitation with relative references and conditiona formatting. any other ideas on how to achieve what i'm looking to do and get around this issue? the alternative is to create this rule cell by cell?