Data Validation with Conditional Formatting
The concept is basic, but the potential application could be GREAT.
Effectively what I am asking for is for either:
Data validation to be expanded to include conditional formatting options. E.g. Allow data validation to include conditional formatting rules and/or the inclusion of data bars, colour scales and icon sets.
Create a bridge between Conditional Formatting and Data Validation to allow cross collaboration between the functions. E.g. pull data validation into Conditional Formatting options and vice versa. For instance how there is a custom/formula option in both Conditional Formatting and Data Validation.
The introduction of this would eliminate the need for building unnecessary stacked formulas and processes within spreadsheets to achieve the same result.