View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charles
 
Posts: n/a
Default 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?