Hi,
Is the following possible with conditional formatting:

If cell A1 is blank then the normal format for A2 (which has a list entry
drop-down box) is a dark blue background and contains no text..
However if cell A1 contains the text "Miss" then cell A2 should have a
background of light yellow, which indicates text entry required.

Here's the bit
When the text has been entered in A2 the cell background (of A2) should
revert to dark blue with the text white. Can it be done??

Sandy