I've a large columnar data base with Row1 as header. I wish to create a new column "X" which obeys (e.g.): -

where (say) values An<Bn<Cn<Dn then Xn is a (specified) fill colour

Try as I may - I cannot get Excel 2007 to conditionally format to this seemingly simple requirement -

Please can someone advise...