Most people set up a dropdown list to make spreadsheets smarter with Excel's data validation. However, the Custom option in the Data Validation dialog accepts any formula that returns TRUE or FALSE, ...

Q: I have an Excel spreadsheet that I update weekly with our employees’ Actual Sales and Sales Goals. I manually insert a red circle to indicate those who did not reach their sales goal by more than a ...