Conditional Formatting. Look at 'Highlight cells that meet specific
conditions' in the Answer wizard


--

HTH

RP
(remove nothere from the email address if mailing direct)


"NN" wrote in message
...
Format cell with colours dependent upon IF result