Hi,

I have created a spreadsheet with some drop down lists. I have created my
lists by naming ranges of cells (with the list options) on a seperate
worksheet and then used Data Validation to select the list. One of my lists
is simply YES, NO, N/A and I want the NO part to always appear in red on the
drop down list. I have coloured the word NO on the named range of cells that
create the list but when you actually use the list in the main worksheet it
defaults back to black.

Does anyone know how I can set this so the NO option on my list is always in
red.

Thanx,

Matt.