Hello All. I have a weird problem. Doing some simple conditional formatting. Want to fix one set of cells and then copy all formatting (font, size, conditional formatting)
using the format painter tool to many locations across different rows and columns. Screenshot show problem.
- Line 22: If I include $ for column reference in conditional formula (absolute reference) the formatting works as desired.
- Line 2: If I use only relative reference for columns in conditional formula then only first column is correct.
While this is a simple fix I have to copy formatting across many sets of columns and each one has be changed to the correct column reference in the conditional formula.
I am using Excel 2010 on a Windows 10 machine. Any thoughts?
using the format painter tool to many locations across different rows and columns. Screenshot show problem.
- Line 22: If I include $ for column reference in conditional formula (absolute reference) the formatting works as desired.
- Line 2: If I use only relative reference for columns in conditional formula then only first column is correct.
While this is a simple fix I have to copy formatting across many sets of columns and each one has be changed to the correct column reference in the conditional formula.
I am using Excel 2010 on a Windows 10 machine. Any thoughts?