Try...

Select the 14 boxes (cells) and give them a defined name with local
(sheet-level) scope, then while they are still selected enter the
following Conditional Formatting formula...

=COUNTA(Inputs)=14

...where the range is named as follows...

Name: 'Sheet1'!Inputs

...and set your fill color.

Replace 'Sheet1' with the actual sheetname, and be sure to wrap it in
apostrophes (required if it has spaces) followed by the exclamation
character.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion



---
This email is free from viruses and malware because avast! Antivirus protection is active.
http://www.avast.com