I am trying to do a value comparison across hundreds of rows. For each row I have a specific upper and lower bound that each cell in that row needs to fall between. If the value in a cell doesn't fall within those bounds, I want that cell to be highlighted. I am using Conditional Formatting and my problem is that I want to use relative referencing and Conditional Formatting keeps defaulting to absolute reference ($). Writing my own formula doesn't work and neither does using the formatting rule options that Excel provides. Is there some setting somewhere that I can activate or deactivate that will prevent Conditional Formatting from automatically defaulting to absolute reference? I also tried putting the bounds I need into separate cells and comparing each cell to those bounds. The "Applies To" box ends up switching to Absolute Referencing as well.