If I use the following formula to count the Es in a rang
=COUNTIF(E15:E26,"E") I can use conditional formatting to advise peopl
making entries into that range if there not enough or too many.

is it possible to write some vb code that defaults the value of th
active cell to 0 if value of the countif function is 3

This will place the active cell outside the list paramenters of th
conditional formatting and trigger an error message which is what I a
afte

--
Message posted from http://www.ExcelForum.com