+ Reply to Thread
Results 1 to 3 of 3

Conditional Formattrying to express

  1. #1
    George Gee
    Guest

    Conditional Formattrying to express

    Hi all,

    Can someone help me with this conditional format problem?

    I am trying to express the following:

    If the number in cell B3 can be found in the range J1:O1,
    then the condition is true.

    The number in B3 is constant (35), the values in range J1:O1
    change weekly.

    Many thanks

    George Gee



  2. #2
    Peo Sjoblom
    Guest

    re: Conditional Formattrying to express

    Use formula is and

    =COUNTIF(J1:O1,B3)>0

    --

    Regards,

    Peo Sjoblom

    "George Gee" <[email protected]> wrote in message
    news:[email protected]...
    > Hi all,
    >
    > Can someone help me with this conditional format problem?
    >
    > I am trying to express the following:
    >
    > If the number in cell B3 can be found in the range J1:O1,
    > then the condition is true.
    >
    > The number in B3 is constant (35), the values in range J1:O1
    > change weekly.
    >
    > Many thanks
    >
    > George Gee
    >
    >




  3. #3
    George Gee
    Guest

    re: Conditional Formattrying to express

    Peo

    Many thanks, the formula is spot on!

    George Gee

    *Peo Sjoblom* has posted this message:

    > Use formula is and
    >
    > =COUNTIF(J1:O1,B3)>0
    >
    > --
    >
    > Regards,
    >
    > Peo Sjoblom
    >
    > "George Gee" <[email protected]> wrote in message
    > news:[email protected]...
    >> Hi all,
    >>
    >> Can someone help me with this conditional format problem?
    >>
    >> I am trying to express the following:
    >>
    >> If the number in cell B3 can be found in the range J1:O1,
    >> then the condition is true.
    >>
    >> The number in B3 is constant (35), the values in range J1:O1
    >> change weekly.
    >>
    >> Many thanks
    >>
    >> George Gee




+ 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