Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Apr 28, 2023
Solved

I need help with conditioning formatting also a count

I need help with conditioning formatting When you reach to 25 it make font bigger change font to dark red & also strikeout whole row with data in it. I have highlight in black I need count of col...
excel
Formulas and Functions
office 365
  • sf49ers19238597's avatar
    sf49ers19238597
    Apr 30, 2023

    I found the answer that works for me. 

    The formula is

    =COUNTIF($C$2:$C$26, 25)

     

    Thanks  You

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Apr 29, 2023

Faisal1775 

 

I have done section count how red font I have done will be in cell G5,G14 & G23.

Than subtract 10,15 or 20 from I have done to get answer to Heads left open new room.

I show you look like highlight color yellow, orange, green my formulas is not update when I put 25 by someone new I done in C7. it not update 8 to 9. I need formula count. better what I have.

 

each section inside border get should like highlight color without colors

 

 

 

 

Thanks You very much.

 

 

  • sf49ers19238597's avatar
    sf49ers19238597
    Iron Contributor
    Apr 29, 2023
    I have type it in manually when new 25
      • sf49ers19238597's avatar
        sf49ers19238597
        Iron Contributor
        Apr 30, 2023

        I found the answer that works for me. 

        The formula is

        =COUNTIF($C$2:$C$26, 25)

         

        Thanks  You

Resources