Results 1 to 12 of 12

problem with logical formula for conditional formatting

Threaded View

  1. #8
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,699

    Re: problem with logical formula for conditional formatting

    See attached example.

    I used the range A2:J12 and because of that the formulas used apply to the first row of that range, i.e. row 2 so I used these three formulas

    =SEARCH("cash",$E2) - yellow
    =SEARCH("check",$E2) - green
    =COUNT(SEARCH("cash",$E2),SEARCH("check",$E2))=0 - red

    works as expected, I think
    Attached Files Attached Files

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