Re: $$Excel-Macros$$ formatting cell

Dear Abhishek Thanks for reply. Actually already some value in cell b1. In short I have a date of material received in cell a1 and qty in cell b1. But shelf life of material is only 15 days so i want to highlight that once the 15 days over I cant put formula in B1 so I want conditional formating

Re: $$Excel-Macros$$ formatting cell

The formula is to be used in conditional formatting dialog box only...not in B1. PFA sample attached. On Thu, Dec 31, 2015 at 3:00 PM, Shrinivas Shevde wrote: > Dear Abhishek > Thanks for reply. > Actually already some value in cell b1. > In short I have a date of

Re: $$Excel-Macros$$ formatting cell

Dear Abhishek Thanks sir Problem Solved Regards Shrinivas On Thu, Dec 31, 2015 at 3:39 PM, Abhishek Jain wrote: > The formula is to be used in conditional formatting dialog box only...not > in B1. > > PFA sample attached. > > On Thu, Dec 31, 2015 at 3:00 PM, Shrinivas

Re: $$Excel-Macros$$ formatting cell

You can use below formula in B1 and set desired format. Then copy B1 and select rest of the cells where you want the formatting and use Paste Special > Formats. *=AND(A1<>"",A1<=TODAY()-15)* On Thu, Dec 31, 2015 at 11:50 AM, Shrinivas Shevde wrote: > Dear all > One