Data validation with custom number formatting

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.

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>