Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: Conditional formatting ? numbers match highlight?

  1. #11
    Board Regular
    Join Date
    Mar 2016
    Posts
    1,547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    ​ok yeah I screwed up it works now thanks agina

  2. #12
    Board Regular 63falcondude's Avatar
    Join Date
    Jan 2016
    Posts
    3,542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    Quote Originally Posted by zone709 View Post
    ​ok yeah I screwed up it works now thanks agina
    You're welcome. To answer your question, COUNTIF checks a range for a criteria. The range is all of the data in columns M through R and the criteria is C3. Conditional formatting then checks M:R for D3, E3, etc. as well as C4, C5, etc.

    A result of 0 is seen as FALSE while a result of anything >=1 is seen as TRUE.

  3. #13
    Board Regular
    Join Date
    Mar 2016
    Posts
    1,547
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Conditional formatting ? numbers match highlight?

    Quote Originally Posted by 63falcondude View Post
    You're welcome. To answer your question, COUNTIF checks a range for a criteria. The range is all of the data in columns M through R and the criteria is C3. Conditional formatting then checks M:R for D3, E3, etc. as well as C4, C5, etc.

    A result of 0 is seen as FALSE while a result of anything >=1 is seen as TRUE.
    Thanks makes sense

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
This website uses cookies
We use cookies to store session information to facilitate remembering your login information, to allow you to save website preferences, to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners.
     


DMCA.com