Using "$" to reference same column in every row
In column F of every row will be a particular value, let's say, "XYZ".
I want to use Conditional Formatting so that the the whole ROW turns to a
yellow background if column F of THAT row has a value of "XYZ" in it.
I use "Formula is"... =$F$2="XYZ", but when I copy the formatting to other
rows using "AutoFill" all the cells point to F2's value instead of the F in
its own row.
What am I missing?
|