OK, disregard the two questions above as I'm now aware you can't format
cells to that degree using conditional formatting (although please feel
free to enlighten me if I'm incorrect!)

However, I now have another question...

I have a list of postcodes which correspond to a certain value (AB).

If cell O2 contains one of the postcodes in the list (on sheet 2), I
want cell AN to display 'AB'. If the postcode in O2 does not appear on
the list, I want cell AN to display "CD"

At the moment, I've got this formula in cell AN2...

=IF(O2=SHEET2!A2:A190),"AB","CD")

But everything is returning CD, regardless of whether cell O2 contains
a postcode within A2:A190 or not.

Can anyone help?!


--
monkeydan
------------------------------------------------------------------------
monkeydan's Profile: http://www.excelforum.com/member.php...o&userid=36982
View this thread: http://www.excelforum.com/showthread...hreadid=567038