Forum Discussion
Conditional Formatting Nightmare
Help please! Does anyone know how to get a conditional formatting formula that you copy from one cell to another to automatically update the formula in the rule based on the cell you are in like a formula does when you copy it. Using the formatting painter copies it exactly like it is in the cell you are copying. That is now what I want. For example, one cell that has this conditional formatting rule =($G2>=50)*($I2<>"X"). I need that same formatting rule copied to the cell below it but it would need to say =($G3>50)*(I3<>"X"). I need that copied all the way down and it needs to change based on the cell that it is in. I have 500 rows and multiple columns that have conditional formatting rules. Doing it one at a time is miserable. Any ideas out there from all the smart people?
1 Reply
You just need to use the first formula you have listed:
=($G2>=50)*($I2<>"X")
The dollar sign in front of the G and I make the reference change automatically. Please see the attached file for reference.
Apply to a range like this:
