Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Conditional Format for public holiday (Excel 97)

    I have a spreadsheet attached that I knocked up quickly as a planning calendar. I obtained help some time ago in relation to this issue, but am now unable to find that post. The Conditional formatting formula shades the weekdays and is supposed to also shade public holidays using the dates in the Rates Sheet but doesnt..

    =OR(WEEKDAY(C$44,2)>5,NOT(ISERROR(MATCH(C$44,Holid ays,0))))

    Sadly it is not working and I cant figure out why?



    Help
    <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Format for public holiday (Excel 97)

    The range 'holidays' refers to a range in workbook ='D:My Documents[Test Calendar.xls]Rates'!$F$3:$F$28

    Change the range name definition of 'holidays' to =Rates!$F$3:$F$28 and it should be fine.

  3. #3
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Conditional Format for public holiday (Excel 97)

    I am having a real der brain day! An Excel question in Word was a good start.

    Can you tell me exactly how I change the range name definition? Sorry...............

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Format for public holiday (Excel 97)

    Go to the insert menu, Select Name, choose define, edit the range name / definition here.

    HIH

  5. #5
    4 Star Lounger
    Join Date
    Apr 2002
    Location
    Northern Territory, Australia
    Posts
    471
    Thanks
    16
    Thanked 0 Times in 0 Posts

    Re: Conditional Format for public holiday (Excel 97)

    Thanks Kieren

    That helped. I just needed a kick start once again.

    Bye for now.

Posting Permissions

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