Hi

I have misunderstood. I've had a look at your spreadsheet. So what you want
to do is highlight the whole column if there is no E, no D and no N in the
column? If any column has E, D or N it stays as it is?
Select the whole area (from B4 to AF21) and go to Format/Conditional
Formatting. First of all, delete the existing formats using the Delete key.
Then set Formula Is and try this:
=AND(B$4:B$21<"E",B$4:B$21<"D",B$4:B$21<"N")

Hope this is what you want!
Andy.

"Memnok" wrote in message
...

Hi

Select your columns, say A through to G, then go to Format/Conditional
Formatting. Select Formula Is and try this:
=OR(COUNTIF(A$2:A$100,"E")=0,COUNTIF(A$2:A$100,"D" )=0,COUNTIF(A$2:A$100,"N")=0)

Hope this helps.
Andy.

Andy, thanks, I think we are on the right track! I was not sure it
this was possible. I went into the schedule and highlighted the range
that I wanted the formula to check and applied it in the Conditional
Formatting screen. I had the format fill with yellow. The only
problem is that it highlights the column next to (to the right of) a
column without a value of “E” “N” and “D” preset.

I uploaded my experimental schedule to
http://home.pacbell.net/memnok/Schedule.xls

Maybe you could take a look? The range selected for this formula to
check is B4 to AF21.

Thanks,
Clint


--
Memnok[/color]