Bob's reply required you to be able to use VBA - that is fairly advanced
stuff.

With Conditional formatting (Formatconditional formatting), you can
set the format according to what is in the cell OR what is in another
cell in the same sheet.

So if you want the the drop down box to be Red if there is 'N0' in it
Condition1 Cell ValueIs equal to="No"

Then select format and you gett he chance to select the coulour of the
font, cell infill and border.

Then select 'ADD' and you get the chance to set another format - e.g.
for Yes. Repeat the process.

You can use al the normal Excel rules like IF, AND etc to build up
complicated setups.

Hope this helps

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=504334