Hello Excel Masters! You have not failed me yet! I have a tough one here:

I have a range of data in a single sheet, from A3 to T500. I have set a conditional format rule, using a formula, in cell T3, such that, if $T$3="C", then the entire row of $A$3:$T$3 is colored light green. It works great.

Now, I want to establish this same conditional format rule for every row 3 through 500. I want to "copy" the conditional format rule I made in T3 on down to the last row of my data. Is this possible, or do I need to manually add a conditional format rule to each row at column T?

Thanks for the help!!

Chris From Tulsa, OK