+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting based on a positive number in a cell

  1. #1
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Conditional Formatting based on a positive number in a cell

    I am trying to create a conditional formatting based on another cell having a positive number.

    If cell C16 is a positive number, then cells A16 & B16 will fill/shade with a color.

    I am not sure if this needs to be done with a formula or if there is another way.

    Thanks for any help.

    Nick
    Last edited by avidcat; 07-08-2010 at 05:52 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,436

    Re: Conditional Formatting based on a positive number in a cell

    Select A16:B16 and add conditional format, Use a Formula to determine which cells to format.

    Use this formula, assuming you count zero as positive.

    =$C16>=0
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    12-15-2005
    MS-Off Ver
    Office 2007
    Posts
    346

    Re: Conditional Formatting based on a positive number in a cell

    Thanks, works perfect!

+ 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