VBA Help on Date Validation that compares on the date today and will be highlited

[doms123]

Im using Excel2007 and i have a sheet and a button that checks or compare the date i enter with the date today

example

Name sex validation today
doms male 03/30/11 04/26/11
nicas fema 04/26/11 04/26/11
congi male 04/29/11 04/26/11

then if the date today and the date of validation will be equal the whole row will be highlited in color yellow if the date today hass passes by the date of validation like on the row of doms it the whole row will be higlited with red it means it surpass the validation date.

Please help me with the VBA code that i need to input on the button...

Thank You in Advance....

 

[jim may]

No VBA code needed....

Why not use Conditional Formatting by first selecting the row header 2 to 1000(?),
then on the Home Tab Conditinal Formatting - New Rule... choose Use a formula to determine which cells to format; In the textbox enter =$C2=$D2 then Format... (Button) select Fill - Yellow. OK, OK

You should be back to the Spreadsheet - Do not Unselect your range from above; Now
click on Conditional formatting again, this time Manage Rules, Choose New Rule, then select formula to determine which cells to format; In textbox enter =$C2<$D2 then
Format (Button) select Fill - Red. OK, OK.

Jim

 

[doms123]

Thanks Man... What a big help!!!