Hi is there a way of copying just the cell interior color from a cell that has conditional formatting in it.
I want to copy the cell from one workbook book1 to cell C3 in book2 that hasn't got conditional formatting.
no, conditional formating doesnt colour the interior of the cell, but meerly masks it.
in order to colour something else the same you would need to use the same method as in the condition
eg if condition in workbook 1 = if cell is greater than 10
in woukbook 2 the interior colour macro would need to be if workbook 1!A1 is greater than 10 etc for it to work
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
