I have several lengthy reports with some very complex colour formatting of data from crosstab queries.
For example:
The complexity of the CF means the report can be very slow to load and can take well over a minute on older PCs
So, when selecting the report, a message box pops up giving users the option of printing a version without CF ... which loads instantly.
There is no need to have two separate reports for this. Use the message box to set the value of a boolean global variable blnCF (or use a tempvar) and use that as an OpenArgs argument when opening your report.
DoCmd.OpenReport "YourReportName",acViewPreview, , , , , , blnCF
Then in your report, check the value of blnCF and run the conditional formatting if its true