I've a column I'm applying this to, a 3 color gradient format which works unless cells that contain the div error are present, then the formatting doesn't work at all no where. So how would you get it to ignore those cells? The formatting rule is based on numbers. Do I need to if a if() statement in there to exclude non-numeric values? Thanks