How do I copy a conditional format from a cell without increasing the range that the formatting applies to? I am able to copy and paste special "format" for one cell without increasing the range, but this is time consuming. I wanted be able to copy a string a cells, paste the format and have the range only apply to a single cell. When I paste the format it lumps all of the cells that I just formatted into the range as well.
Thanks,
Chris.