Dear Expert, One last thing to remind that Color bar should increase or decrease when duration is changed. Please help in this matter with Excel logical formulas & conditional formatting, only. Try to avoid VBA, if possible. Thanks
Regards, Zafar Iqbal ------------------------ On Mon, Aug 29, 2011 at 11:03 AM, Zafar Iqbal <ziqba...@gmail.com> wrote: > Dear Expert, > > Thanks for sparing time for my question. You are right in indicating five > conditions. > > Case Result Cell Color > Condition-1 0 No If Dur1,2,3 is Zero or blank > Condition-2 1 Green If Dur1>0 > Condition-3 2 Yellow If Dur2>0 > Condition-4 3 Blue If Dur3>0 > Condition-5 x No If WO1,2,3 = On Leave > I shall be very thankful to you for this great help to solve this problem. > > Regards, > > Zafar Iqbal > ------------------------------------------------- > > On Sun, Aug 28, 2011 at 8:36 PM, XLS S <xlst...@gmail.com> wrote: > >> hey Zafar, >> >> i think there is 5 condition... >> 1st if result is 1 >> 2nd if result is 2 >> 3rd if result is 3 >> 4th if result is 0 >> and 5 is if On Leave >> >> if is it ok then give the confirmation, then i start the work > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
