• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto highlights

H

Harsha

New Member
Hi Chandoo,


Am very Happy coz of learning a lots, lots of Tips and Trick in Excel sheet from you.

and am happy and will be happy to see your a updtaed (NEW) tricks and tips mails from you......


and now my Issue is ?


i was calculating some Revenue Reports.

i have give Range of Prices to different Products (like Grades)

to calculate automatically i have given =Today() formula (to know till date GRADE/RANGE of the product)


for Ex:- Product 1 - Range is B till Date

now i have to give formula to Highlight the changed GRADE/RANGE of the product if it crosses yesterday (Date)


so that i can know that at this date this has been changed to this GRADE/RANGE

like that


can you help me in this.
 
Hi,


Take a look at this link on Conditional Formatting with dates, that could help you


http://chandoo.org/wp/2010/01/05/conditional-formatting-dates/
 
You must log in or register to reply here.
Back
Top