Excel 2007/2010 Conditional/Formula Formatting multiple possible

Ok I have a spreadsheet that calculates schedule hours for a 2 week period of time/total of one month. So the box would have 80 / 80 if both pay periods were complete. If not it would be 48 / 80 or ## / ##. No of course when I first start making the schedule it is 0 / 0.

In this COLUMN there are headings/other things in other places as well. IF possible I would like it to leave the box NO FILL when the value is 0 / 0, or any other text/blanks, etc.

If it is ## / ## I would like it to FILL the box RED (basically highlighting that the hours are not complete, and then FILL GREEN when the value = 80 / 80 letting me know they are scheduled for their total hours of the month.

So I can do conditional formatting with 80 / 80 and set it to FILL green, but if I do NOT EQUAL or anything else ofr the colors it wants to set ALL of them NOT equal to other colorrs...

any help is appreciated...

I was even going to just say FONT colors using CUSTOM FORMATTING
[GREEN][="80 / 80"]## / ##;[Black][="0 / 0"]# /#;[RED]## / ##

but that didn't work... for some reason keeps changing the values to 80 or 0 and ignoring it... I guess that custom formatting only goes with greater than numbers, etc

Can you use this conditional formatting formula for Red?

=AND(A1<>"0/0",A1<>"80/80")

where A1 is top most cell in your selection

How about:

=AND(SEARCH( "/ ",$AD1),$AD1<>"0/0",$AD1<>"80/80")

this will also check that the cell has a " / " so it shouldn't colour cells with text (as long as there are no " / " in it.