validation help

M

markmeadows1

Joined
Apr 10, 2011
Messages
1
Reaction score
0
hi ive looked all over for this but can find what im looking for :(

cell b1 has a count if forumula =COUNTIF(B2:B17,"ah") i need a validation so that cell b1 does not go over 10 and if it deos give a warning. cell a1 has Conditional Formatting but the department still book holidays above the level so i need a warning and help with the validation on cell b1 with whole number between 1-10 but it still lets you go over

any help on this would be great
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel conditional formatting with Weeknum 4
Using Validation Ref # within LOOKUP 3
Conditoinal formatting 2
Validation problem. 3
Data Validation - Preventing Delete from Delete Key 2
help with data validation 2
Flash Cards for my 1st grader 12
Using named formula in validation 8

Top