Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Oct 2003
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting based on another cell (2007)

    How do you get Excel 2007 to format a specific cell (say C1) based on whether or not A1 is populated (say A1>0).

    I love the new conditional formatting of 2007, but can't figure out how to do this process that is easily completed in earlier versions?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Conditional Formatting based on another cell (2007)

    Select New Rule or Manage Rules, then New Rule from the Conditional Formatting dropdown.
    In the New Formatting Rule dialog, choose "Use formula to determine which cells to format".

Posting Permissions

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