How do I copy conditional formatting from one cell to another using Excel 2007?
Set your conditional formatting on the first cell. Make sure that the formula doesn’t have the $ in the cell reference that your are comparing to. Excel will put the dollar signs in by default. Once you have the first cell set just select it and copy then select all the cells you want formatted the same and hit pastespecial and paste only the formats.
