How to change date format using jquery?

I want to format spreadsheet so the row changes colour when a date is selected?

• I have a spreadsheet with a series of drop down menu's, In the O line I have the completion date when this date is entered I need to the entire row to change colour Please walk me through as this is using excel 2003 and I have been using 2007 for a while Thanks

• Answer:

  I hope that you mean that the O line is the O column. In P1 enter O1=TODAY() Copy down the whole column or as far as you want. This will give "True" or "False" in column P. Click on Conditional Formatting. Manage Rules, New Rule, Use Formula and enter this in the formula field: =AND(A1:P1) click in Formatting and choose what you want. In the Applies to field enter: =$A$1:$O$10000 This will apply the conditional formatting to 10,000 rows where ever the condition in column P is "True". Change the references to apply to you data.