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 f...
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: