Forum Discussion
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
- SamM750Copper 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
- OliverScheurichGold Contributor
This works in my sample sheet.
- SamM750Copper 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.