Pivot table form

M

Mike Kelsall

I have a pivot table form based on a query
the data contains names and course dates in the following format
Course
Gas Check Oil Check
Name Date got Date Expires Date got Date Expires
Peter 1-1-2007 1-1-2010 1-2-2008 1-2-2010

i am trying to make the form highlight the date expires field if it is less
than todays date

cant get the conditional format to work
must be missing something

any help would be appreciated

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table Days to Months 0
Conditional Formatting Training Expiry Dates 2
Another Date ? Continued 1
Displaying Text Data in Pivot Chart 0
Expiry dates query 1
Date of 1/14/2010 and on not working in form 2
Calculated Field 4
DATE Calculations in pivot table 0

Top