I'm not sure that it's possible with xl 2003 because the conditionnal formating must be the same as the range of apply. In xl 2007 and 2010, you can make a test to a range of cell (O2:AS2 in your example) and apply the result to O3:AS11.
The conditionnal formating has changed a lot with the new version of excel and that's a very good point :) On 25 août, 09:37, 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 > > Conditional Formatting.xls > 63KAfficherTélécharger -- ---------------------------------------------------------------------------------- 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
