Conditional formatting after copy paste

[Ninad7]

Hello Guys, I have made an excel file where when you enter any value in the cell it turns red and it remains normal when the value is coming from formula. I have used conditional formatting =NOT(ISFORMULA(A1)). But now, when I am done working on the file and want to send it to others, I can not send the file with formula to them. So I have to copy the cells and paste it in value but this makes all the cells red because of conditional formatting. Any solution to this? I can not make a new file and copy paste it because its a very huge file.

 

[Joe4]

Is the Conditional Formatting important to them?
Is there any other pattern by which to identify which cells should be colored and which should not (i.e. every even row number, or certain columns, etc)?
Can you print the file to a PDF and share that with them, or do they need to have it in Excel format?

How much data are we talking about?
How many sheets?
How many rows?
How many columns?

 

[Ninad7]

Hi Joe,
1) The conditional formatting not important to them. It is only important to me. It is for my reference.
2) There is no pattern.
3) They need it in excel format.
4) 8 sheets (but the conditional formatting is on 1 sheet only.
5) Around 80 to 85 columns and 500 rows on the main sheet.

Thank you

 

[Joe4]

1) The conditional formatting not important to them. It is only important to me. It is for my reference.

If that is the case, why not just remove all Conditional Formatting before converting all formulas to hard-coded values?
You can even create a Macro to do both on all sheets with a single-click.