Forum Discussion

SamM750's avatar
SamM750
Copper Contributor
Apr 21, 2025

Conditional Formatting code help

I have 300o rows that I need code in, is there a faster way to write this so I don't have to write a policy rule for each row?

What I need to accomplish: If "Dismissed" is selected in Column C I need it to turn Cells A,B, & C in that row Yellow but only that row. Above is the only way I can think to do it but then I would have to basically copy and change the row # from Cell 3 to 3003 and boy I'd really like to avoid having to spend the time doing that. I'm sure there is a way to do this in a much simpler faster way, I just can't think of how to get it done other than the way I don't want to do it.

3 Replies

  • SamM750's avatar
    SamM750
    Copper Contributor

    Oliver,

     

    I believe I tried it that way and it kept turning them all yellow, let me try that again is your sequence =$A$3:$C$3000

    • SamM750's avatar
      SamM750
      Copper Contributor

      Oliver,

       

      You are awesome, I swear I tried that....I thought I did anyway...but works like its supposed to now. Thank you sir.

Resources