Colour alert in excel after a date??

[arshadbh]

Hi All,

After 05-JULY-10 a perticular a complet raw should turn into red colour to alert me that its time up to send the invoice. is there any formula available in excel 2007?? If a complete raw is not possible atleast a coloumn can be turn to red colour??

please help me.

Thank you

 

[yogeshmaney]

Try conditional formating

 

[Libra0099]

Try conditional formatting....

 

[arshadbh]

HI Yogeshmaney,

Thank you for you kind reply, please explain me what is "conditional formatting" and how to do it??

hope to hear from you soon.

thank you

 

[Libra0099]

Hi,

If you are using Excel 2007 please see below the path to reach conditional formatting...

In the excel worksheet click on the Tab "Home>conditional formatting>Highlight cells rule>Greater than


Hope this will serve ur purpose!