Data Validation

[Snowmonster]

Hi All...

I just went to access my Data Validation drop down box, to add a warning message, and it came up with the following message: 'The selection contains more than one type of validation. Erase current setting and continue. Ok Cancel'

If I okay it, I will loose all my formulas in the content, if I cancel it wont let me in.

Any ideas on how to open it without deleting the content, please?

Snowmonster

 

[crusader]

Hi All...

I just went to access my Data Validation drop down box, to add a warning message, and it came up with the following message: 'The selection contains more than one type of validation. Erase current setting and continue. Ok Cancel'

If I okay it, I will loose all my formulas in the content, if I cancel it wont let me in.

Any ideas on how to open it without deleting the content, please?

Snowmonster

Highlight each range for which you have a different validation separately.