I have a couple of questions:
Is it possible to make a conditional formatting or data validation rule such that multiple data types can be input into a cell and the cell will automatically separate the data and format the cell depending on the data entered? For example:
In the example above, is it possible to make another sheet retrieve the data in the above example cell, separately? For example:
Alternatively, is it possible to make a cell call the formatting of another cell, such that if example 1 is not possible, the cell can be manually formatted a certain color such that another cell can call that formatting and determine the data type?