Results 1 to 3 of 3
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Conditional Formatting Problem Solved (XP - but probably earlier as well)

    Hey, I just solved a little question in Conditional Formatting that I had and thought other loungers might find the solution useful as well. I was fooling around with a scenario where I wanted conditional formatting to highlight if a linked value from another spreadsheet was zero (indicating that data hadn't yet been entered into the spreadsheet).
    Then I ran into the problem that Conditional formatting will not accept references to another sheet or workbook.
    Solution: Give the cell a range name, use the range name in your formula and then reference the range name in Conditional Formatting condition.

    hope this is useful.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Formatting Problem Solved (XP - but probably earlier as we

    This "Trick" works in Datavalidation as well to reference lists (for example).

    Steve

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Conditional Formatting Problem Solved (XP - but probably earlier as we

    The "magic power" of range names.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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