Need help with Date code

[Javi]

Hi all,

I have a date in column H1 and a number in column i1. *I'm looking for a code that will change the background color of H1 when the number of days in i1 are exceeded.*

H1. * * * * * * * * ** i1.*
09-04-2011. * * * * * * *30*

On 10-5-2011. Cell H1 will now have a red background.*

This code will need to run every time the sheet is opened.*

Thank you in advance for your help.*

 

[Marcelo Branco]

You can achieve this with Conditional Formatting

Select H1

Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format

enter this formula

=TODAY()>H1+I1

Format... button
Fill > pick red
ok, ok

HTH

M.