excel sheet formula help

[faisalsgr]

hi sir,
i wana make a sheet that contain a data.which is that when i putt a product and his validation is 6 month and when 6 months finished this product name or cell,s colour apear red so in all sheet i will be see that those items apear red they are expired please help me to creat it.

thanks

 

[Sektor]

1. Select cells.
2. Go to Home tab -> Conditional Formatting -> Manage Rules -> New Rule -> Use formula to determine which cells to format.
3. Type in: =DATEDIF(A1;TODAY();"m")>6
4. Press "Format" button and choose desirable formatting.