+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting Issues

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Brookfield, Wisconsin
    MS-Off Ver
    Excel 2003
    Posts
    13

    Conditional Formatting Issues

    Hopefully someone can help me out on this. I have an excel sheet that I use to track a "Quota" for my golf league. Last year we had the rule of:

    However many multiples of 2 you shoot over or below your last weeks quota, your quota goes up or down by 1. (ex. your quota is 20 and you shoot 22, your quota for next week would be 21. If you shoot 24, your quota for next week would be 22. Same process for shooting below your quota ex. if you shot 18 your quota for next week would be 19, or if you shot 16, your quota for next week would be 18). Quota remains unchanged for any odd numbers.

    This year we are changing the rules a bit. Rule remians the same as above for any score above your quota, but you need to shoot multiples of 3 below your quota for your quota to drop 1.

    I received help last year (attached sheet) but cant figure out how to modify it for the new rules.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-22-2010
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Conditional Formatting Issues

    I also have a conditional formatting issue. I have a summary sheet and then other data sheets. On my data sheets I have put in conditional formatting. The summary sheet pulls in from the data sheets but it does not pull in the formatting of the cell. Is there any way to do this without having to do all the conditional formatting again?

    Thanks!

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Conditional Formatting Issues

    ebartlett,
    welcome to the forum. However,

    Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1