Hi, 

How can I copy a cell or multiple cells from one spreadsheet that has conditional formatting applied to it (turns font red if formula criteria is met) tp a different spreadsheet / cell(s)?

Not sure this is possible, but had hoped there was an option similar to doing a paste / values?

Thanks,

Chris

Hi Chris,

You can just use Ctrl+C and Ctrl +V to copy and paste the range with conditional formatting to another worksheet or even another workbook, the conditional formatting will still be there.
If you get any problem when you try this sort of thing, please let know.

Wind Zhang
TechNet Community Support

Hi,

Unfortunately, I just can copy the cell that is getting formatted.  I cannot copy over the cells that are part of the conditional format.

So, let's say I have two cells, A1, B1.  A1's value is 1234.  B1's value is ABCD.  B1 has conditional formatting in it that turns B1's font red if A1's value is 1234, so B1's value ends up being ABCD (in red).

If I just do a ctrl C and ctrl V of B1 to another spreadsheet, I'll get ABCD in black.  

thanks,
Chris

Sorry ,from your original post, I thought you want to copy all of the related cells to an new worksheet.

Did you want to copy the text color with conditional formatting?( In you case ,if cell A1's value is not 1234, the color of the cell you copied to another worksheet will change too)
If so, you can copy the range and Paste Special->Keep source column widths(W).

If you want to copy only the format, but not keep the conditional formatting rules. It will be difficult
to achieve, you will need to use VBA code to get the conditional formatting color, then copy it to the target range.

Best Regards,
Wind