Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to copy conditional formating down a column.

The values are based on VLOOKUP formulas.

When I compare J2 to F2, everything works.

When I copy the Formatting down the column, every cell is compared to F2.

I have tried dollar signs but to no avail.

Can someone help please?

share|improve this question
    
Hi Alex, welcome to SuperUser. We'll need some more info before we can help you though. Can you please confirm what version of Excel you are using and can you provide the conditional formula, and the cell formula you're using? –  CLockeWork Oct 17 '13 at 13:28
    
Dollar signs make the reference fixed so when you copy a cell it will always reference the same cell. Is that what you want? Did you try $J$2 versus $J2 or J$2. Whatever has the $ will be fixed otherwise the autofill will adjust the formula based on location from original cell. –  Portland Runner Oct 17 '13 at 17:13
    
Hi.I'm using Excel 2007. The formula is a vlookup <br> =IF(ISNA(VLOOKUP(A3,BRIT,9,FALSE)),"",VLOOKUP(A3,BRIT,9,FALSE)) [br] to fill data from different sources, then toestablish whether one column is different than another the Conditional formatting is to add colours according to Greater than, Less than or Equal to. –  Alex Oct 18 '13 at 8:25
    
Hi.I'm using Excel 2007. The formula is a vlookup =IF(ISNA(VLOOKUP(A3,BRIT,9,FALSE)),"",VLOOKUP(A3,BRIT,9,FALSE)) to fill data from different sources, then to establish whether one column is different than another the Conditional formatting is to add colours according to Greater than, Less than or Equal to. So far, I have tried creating the formula in in J2 to compare it to F2. I have tried both $ ($J$2>$F$2), left a $ next to the column ($J2>$F2) and removed all (J2>F2) then copied the formatting down the column. It has always referred to F2! –  Alex Oct 18 '13 at 8:38
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.