Conditional Format (Macros)

[Fernie]

Could anyone help with the following problem....

I have an Excel sheet that automatical updates daily.
The infomation that i require in reference to conditional format is
based on dates.
When the report opens and runs on a morning i would like it to colour
dates that are 10 days less of the current date to Red, and the rest
to Green.
I have had a look at the conditional format options and im not too
sure about it, if i can activate and run it through excel i should be
able to put it into my macros for when it runs on a morning.

Thanks

 

[David McRitchie]

Take a look at
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Post back if you still have questions.

Formula 1 is: =(A1+10)>=TODAY() format patterns as RED
Formula 2 is: =(A1+10)<TODAY() format patterns as Green

 

[Fernie]

Thanks for the help David i can now enter it into my macros

Fernie

Take a look at
http://www.mvps.org/dmcritchie/excel/condfmt.htm

Post back if you still have questions.

Formula 1 is: =(A1+10)>=TODAY() format patterns as RED
Formula 2 is: =(A1+10)<TODAY() format patterns as Green

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Could anyone help with the following problem....

I have an Excel sheet that automatical updates daily.
The infomation that i require in reference to conditional format is
based on dates.
When the report opens and runs on a morning i would like it to colour
dates that are 10 days less of the current date to Red, and the rest
to Green.
I have had a look at the conditional format options and im not too
sure about it, if i can activate and run it through excel i should be
able to put it into my macros for when it runs on a morning.

Thanks

 

[Fernie]

Thanks for the help David i can now edit my macros

Fernie