Managing CORRECT data entry using cell validation

Hello there,

Got some great help yesterday, but still have a couple of minor issues... firstly the whole (AND/OR) function does not seem to be working as I had hoped and secondly I would really appreciate some help in general tidying up of my document. Please see my problems below and refer to the attached document.

Thanks in advance...

The row does not seem to move if “won” but not green.* I would like the row to move if it is green AND/OR marked as “won”.
*
The row does not seem to move if “lost” or “superseded” but not red.* I would like the row to move if it is red AND/OR marked as “lost” or “superseded”
*
Can I also add rules for entry into particular columns:
*
I would like excel to return “invalid entry” if in the CONTACT NUMBER Column the phone number format is not entered with a country code i.e. “+44123456”
*
Similarly with the MARGIN Column, this figure should trigger a warning “LOW MARGIN ALERT” if under 40%.
*
The PROBABILITY Column should only return figures of 25%, 50%, 75% or 100%.
*
CALL TO ACTION Column, MUST be completed.
*
Is it then possible to automatically fill in the table on worksheet “09-10 Total”? I am looking for total number of valid and quote wins quotes within the month into row 2, in this example it would return 6 valid and 2 won TOTAL of 8 for July.
*
For rows 3 and 4 this would return the values from column “J” or just the rolling total from the current month for row “4”.**
And the carried fwd value from column “J” or just the rolling total for row “3”.
*
The estimate and intake figure will be updated manually.
*
Two other small snags –
1. Is it possible to ensure that all CELLS, ROWS and COLUMNS remain a consistent size throughout the document?
2. Can i ensure that upon entering an email address into column "D" it does NOT automatically create a hyperlink and maintains the same font and size and the other cells?

I really appreciate your guidance.

Dave Cheng