Highlight dates coming near

[jackt05]

Hi everyone,

Plz help me out

i have many dates of various document which have to be renewed often.

i want those dates to be highlighted or remind me of the expiry, continuously

for the last remaining 30 days.

Plz suggest me a formula or code or anything that can help me

Thanks for ur help and

regards

 

[Andrew Poulsom]

You can use Conditional Formatting with Cell value is less than or equal to =TODAY()+30.

 

[jackt05]

thankyou very much problem solved