I am not sure if there is a function for this, but I am setting up a
schedual using Excel. I want to create a formula/function that looks
at a range and checks each column to confirm that there is at least one
value of “E” “N” and “D” preset. There are other values that dont
matter, and it is ok if there is more than one of the required values,
there just needs to be at lease one of each (“E” “N” and “D”). If one
of the columns is missing one of the values I’d like it to mark that
column in some way that makes it stand out (color?).

I have an example .xls file of the schedual at
http://home.pacbell.net/memnok/Example.xls

Thanks in advance for anyone who can help.

Clint


--
Memnok