• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Reproduce Conditional Formatting within workbook sheets

nagovind

nagovind

Member
In a workbok there are many cells which is with conditional formatting so that it is just changing the colour of the cell and the formula say in Sheet1 cell no A1 is with some conditional format so that it is changing the font colour and cell colour based on certain contitions from other cells


Now the query is: Is it possible to CAPTURE the conditional formatting alone from the cell A1 in sheet1 and reproduce the effect in cell B1 in Sheet2 of same workbook


Please advise if there exits any solution


thanks
 
Nagovind


Yes


Copy the cell you want to use as the Source CF

Change to Sheet 2

Right Click the cell you want to transfer the CF to

Paste Special, Paste Special, Formats

Ok
 
You must log in or register to reply here.
Back
Top