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.
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.