| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom function valid in Data Validation/Conditional Format?
Hi all,
Well, I discovered a while ago that we CAN use custom function on either Data Validation or Conditional Format? I am trying very hard to verify myself, but doesn't seem to work either case... With Data Validation, I am writing a function that returns Range and then show all the cell values in drop-down box, which I cannot make it happen... Can someone cast light on this with an example? Thanks for your time. --- Tetsuya |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Custom function valid in Data Validation/Conditional Format?
Try returning the address of the range and use it inside the indirect
function. -- Regards, Tom Ogilvy "Tetsuya Oguma" wrote in message ... Hi all, Well, I discovered a while ago that we CAN use custom function on either Data Validation or Conditional Format? I am trying very hard to verify myself, but doesn't seem to work either case... With Data Validation, I am writing a function that returns Range and then show all the cell values in drop-down box, which I cannot make it happen... Can someone cast light on this with an example? Thanks for your time. --- Tetsuya |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retain Conditional Format When Condition Is No Longer Valid | Excel Discussion (Misc queries) | |||
| Why can't I enter a valid number in a cell with data validation | Excel Worksheet Functions | |||
| Custom Validation Not Accepting Valid Data Revision | Excel Worksheet Functions | |||
| Data Validation or Conditional Format (or combo of) | Excel Worksheet Functions | |||
| Custom Format and Data Validation Q | Excel Worksheet Functions | |||
Linear Mode
