Conditional formatting ? numbers match highlight? - Page 2

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,615
    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,563
    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,615
    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
  •  

 

 
DMCA.com