Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. -- rbekka ------------------------------------------------------------------------ rbekka's Profile: http://www.excelforum.com/member.php...o&userid=14032 View this thread: http://www.excelforum.com/showthread...hreadid=553115 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data validation with custom number formatting
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Custom Formatting a number | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Custom Format and Data Validation Q | Excel Worksheet Functions |