ExcelBanter - How can you use data validation for a cell with a formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - How can you use data validation for a cell with a formula (https://www.excelbanter.com/excel-programming/372832-how-can-you-use-data-validation-cell-formula.html)

Floyd

How can you use data validation for a cell with a formula

I have this cell with a formula = SUM(IF(frequency(A13:A20,A13:A20)0,1 and I
want to give the user an error message if the calculation exceeds 15.
A13-A20 are date entries and those cells needs a data validation also. Can
one cell have 2 data validations? or yet, can this cell with a formula have
data validation?

All times are GMT +1. The time now is 03:01 AM.