If you need to use more than 3 "conditional formats" you'll need to do some VBA coding. Try looking specifically (using the advanced Search options) in the Excel Programming folder of this forum. Otherwise,what I've done in the past is either split the conditional formatting up into 2 cells (duplicate data but up to 6 colors) or decide on the least important condition and drop it. :-/

ChemistB