| Home > Forum Home > Analyzing Corporate Financial Data > Dependant drop down list - prompt to select > Conditional formatting to validate selection | Share |
Conditional formatting to validate selection
Excel Help for Conditional Formatting To Validate Selection in Analyzing Corporate Financial Data
| Forum Topic | Login |
Conditional Formatting To Validate Selection | Rate this: (2/5 from 3 votes) |
 | The simplest approach here is to use a conditional formatting formula in cell E5 to validate that values in both C5 and D5 have been selected. If the length of both selections is 2 a conditional formatting formula for cell E5 could be: Formula Is: =LEN(E5)<4 Alternatively a more complete formula could be: Formula Is: =OR(C5="",D5="") The format can then be applied such as coloring the cell red or text, border highlighting as desired. | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
Excel templates and solutions matched for Conditional formatting to validate selection:Solutions: Conditional Formatting Functions |