Conditional formatting

Kabous07

Registered User.
Local time
Today, 22:37
Joined
Jun 17, 2015
Messages
18
Hi,

I want a cell in a form to be highlighted when a unit is out of warrantee. At the moment we will deliver a unit on site and then from that date we count 18months for warrantee period. So I have two cells, one called warrantee end date and delivery date. If the 18 months has come to pass the warrantee end date must change to red for instance, because the unit is now out of warrantee. Can someone please help me

I did try the below, but can not get it to work:

> DateAdd("m";18; "= [DeliveryDate]" )
 
Did you select "Expression Is"?

The expression itself is wrong too:
Code:
> DateAdd("m";18; [DeliveryDate])
 
Hi vbaInet

I did select expression and try playing around with the expression. The closest I got to was DateAdd("m";18; [DeliveryDate] ), but still did nothing. It wont change to red if I change the delivery date lower than the warrantee end date.
 
If it's lower then change ">" to "<". And if you select Expression Is, then you should put the name of the field in there as well.
 
Aaaah that worked perfectly. I forgot about that. Thank you allot!!!!!!!!!!!!!!!!!!!

>DateAdd("m";18; [DeliveryDate] )
 

Users who are viewing this thread

Back
Top Bottom