Re: $$Excel-Macros$$ Correction required in highlet cell & refresh d15 automatically when last any entry of any raw change

2016-01-10 Thread Pankaj Sharma
message -- > From: big smile <bigsmile...@gmail.com> > Date: Sun, Jan 10, 2016 at 11:19 AM > Subject: $$Excel-Macros$$ Correction required in highlet cell & refresh > d15 automatically when last any entry of any raw change > To: excel-macros@googlegroups.com

$$Excel-Macros$$ Correction required in highlet cell & refresh d15 automatically when last any entry of any raw change

2016-01-09 Thread big smile
Respected All I have attached excel files too It has some still issue . I think there is some correction required in the formula 1] When F column falls under 15 days before today -- only that time full raw should be yellow Today is 9/1/2016 so any date from 9/1/2016 to 24/1/16 -- then

Re: $$Excel-Macros$$ Correction required in highlet cell & refresh d15 automatically when last any entry of any raw change

2016-01-09 Thread Eugene Bernard
Please remove the $ from the formuala =AND(F5<>"",F5 wrote: > > > > Respected All > > I have attached excel files too It has some still issue . I think there > is some correction required in the