+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting formula problem

  1. #1
    Forum Contributor
    Join Date
    01-11-2007
    Posts
    127

    Conditional Formatting formula problem

    Hello

    I have used Conditional Formatting to turn adjacent cells green if $S208>0.

    How do adjust the formula to turn adjacent cells green if $S208 "contains information"

    $S208 could potentially contain a positive or negative number or it may contain text. In either case I want the adjacent cells to turn green.

    Any ideas. Thanks.

    Dan

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Conditional Formatting formula problem

    Hello Dan, make it

    =$S208<>""

    i.e. cell is "not equal to blank"

  3. #3
    Forum Contributor
    Join Date
    01-11-2007
    Posts
    127

    Re: Conditional Formatting formula problem

    thanks, that's great. I am also trying to create another condition where adjacent cells are turned yellow if $S208 is EMPTY and A208 = 'Y'.

    I have tried asking if $S208 is empty (by using this formula: $S208"") but that does not seem to work let alone adding the IF A208 = 'Y' argument to the formula.

    Any ideas how to express these IF's in one formula? Thanks.

    Dan

  4. #4
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Conditional Formatting formula problem

    Dan,

    I notice that you posted this problem, and at least one other, at MrExcel as well as here. That's "cross-posting" and we have a forum rule which forbids that practice unless you post a link to the other post(s). Please post links or I'll lock this thread

    Thanks

+ 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