Use conditional formatting on the cell as well, test the result. See
http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"rbekka" wrote in
message ...

Hi there

I would like to create a list based on data validation. The
complication is being able to format this depending on the selection. I
cannot seem to get a cell with data validation to change color - custom
number formatting doesn't register an input which has been made from a
cell entry using data validation.

Does anyone know how to do this at all? Your earliest response will be
greatly appreciated.


--
rbekka
------------------------------------------------------------------------
rbekka's Profile:
http://www.excelforum.com/member.php...o&userid=14032
View this thread: http://www.excelforum.com/showthread...hreadid=553115