Dear Experts,
I am still waiting for reply from you all. Please help me in this matter.
Thanks
Regards,
Zafar Iqbal
On Sat, Aug 27, 2011 at 10:29 AM, Zafar Iqbal <ziqba...@gmail.com> wrote:
> Dear Expert,
>
> Ref your instructions, please find attached file with conditional
> formatting applied. My worry is about 4th condition "On Leave". My
> conditional formatting gets failed when employee is "On Leave". This may
> occur anywhere in
> Assignment-1, 2 or 3.
> On Leave condition should be mentioned as "x" without any color.
> Color pattern should not be disturbed whenever "On Leave" condition is
> applied. Assignment-1 (Light Green), Assignement 2 - (Light Yellow) and
> assignment 3 with (Light Blue), always.
>
> Please help me in this problem with formula only.
>
> Thanks,
>
> Zafar Iqbal
>
> On Thu, Aug 25, 2011 at 2:17 PM, XLS S <xlst...@gmail.com> wrote:
>
>> kindly put 3 condition it self and then send file.
>>
>> try this code
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>> Set I = Intersect(Target, Range("B2:B8"))
>> If Not I Is Nothing Then
>> Select Case Target
>> Case 0 To 100: NewColor = 37 ' light blue
>> Case 101 To 200: NewColor = 46 ' orange
>> Case 201 To 300: NewColor = 12 ' dark yellow
>> Case 301 To 400: NewColor = 10 ' green
>> Case 401 To 600: NewColor = 3 ' red
>> Case 601 To 1000: NewColor = 20 ' lighter blue
>> End Select
>> Target.Interior.ColorIndex = NewColor
>> End If
>> End Sub
>>
>> Private Sub Worksheet_SelectionChange(ByVal Target As Range)
>> Range("F1:F1") = Range("F1:F1").Interior.ColorIndex
>> End Sub
>>
>>
>>
>> On Thu, Aug 25, 2011 at 1:07 PM, Zafar Iqbal <ziqba...@gmail.com> wrote:
>>
>>> Dear Excel Experts,
>>>
>>>
>>>
>>> I want graphical presentation of each employee's assignment duration in
>>> days with conditional formatting described in attached sheet.
>>>
>>> These color bars should move forward, backward, increase or decrease
>>> automatically when their duration is changed.
>>>
>>> In Excel - 2003, conditional formatting with only three options is
>>> possible. Here, I have four conditions i.e. Assign-1, 2, 3 and vacation.
>>>
>>> Please help me in preparing this sheet with automatic floating colors.
>>> Thanks in advance.
>>>
>>>
>>>
>>> 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
