"Help"how to lock in conditional formulas on a blank spreadsheet to copy and paste a report

[Diana2rom]

Hello,

so, I have to download a report with multiple jobs statuses, then further I have to filter by different criteria. I have certain formulas that helps me highlight the table by different criteria already while time is of the essence for me. I was wondering if i could set up a blank spreadsheet with the conditional formatting formulas locked in on a sheet for me to just copy and paste the downloaded report on that template and be able to do the highlighting automatically.

Is that possible?



please help if you can

Thank you

 

[RonB1111]

Yes. Use Paste Values instead of just paste.

 

[Diana2rom]

It doesn't work. the previously inputted conditional format formula is gone after I paste the report on the worksheet

 

[RonB1111]

Did you use "Paste Values" (or "Paste Special"-check the Values circle - OK)?

If you did this and it still doesn't work, please provide some more details.