Perhaps because you said to avoid vba. What excel version. Perhaps a sample
file.
From: Zafar Iqbal
Sent: Tuesday, September 06, 2011 2:58 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Conditional Formatting
Dear Experts,
Will somebody inform me that why my request is not getting your kind attention,
please?
Regards,
Zafar Iqbal
On Mon, Sep 5, 2011 at 11:00 AM, Zafar Iqbal <ziqba...@gmail.com> wrote:
Dear Experts,
Still waiting for your kind support.
Regards,
Zafar Iqbal
----------------------------
On Sun, Sep 4, 2011 at 8:11 AM, Zafar Iqbal <ziqba...@gmail.com> wrote:
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
-------------------------------------------------
--
----------------------------------------------------------------------------------
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
--
----------------------------------------------------------------------------------
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
