Dear Experts, Still waiting for your kind response.
Regards, Zafar Iqbal ------------------------------------------------- On Mon, Aug 29, 2011 at 12:59 PM, Zafar Iqbal <ziqba...@gmail.com> wrote: > 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
