"Highlite" a "row" that has a "particular date"

[Steved]

Hello from Steved

I'm using Office 2007

Highlite the "Row" from "Col A: to Col S:"

I would like to please have a message box that will allow me to input a date
ie "22-Jun-2009" which are in the Column C:C, which would goto the row then
from Column A: to Column S: have the Fill colour be "Yellow" and the Text
"Red and Bold".

Thankyou.