I designed an output sheet with conditional formatting to fill a cell with color based on its value. When I test the formatting on the sheet it works as it should. However, when I batch print reports the conditional formatting does not show up. I was wondering if there was somthing I was missing as far as how keylab functions with conditional formatting and output reports. When I am batching the reports I click off the "Remove Colour" option from the box that pops up with print options. I have also left it checked. No difference.
How my sheet is setup:
On the input sheet I have it reference values for a particular specificaion. Using index match I have it reference a table to pull in values based on the test. The values are labeled as such:
Property Top Specification Bottom Specification
1/2 5 -5
3/8 4 -4
etc....
Each top secification and bottom specification has its own propery. So in the example there would be 4 properties associated with it. 12in_top_spec 12in_bottom_spec
This would continue through the table.
On the output report I import the values into a second sheet. So the output report has 2 sheets. The main output report and the table sheet.
I then put the proper reference cells into this table sheet.
It would look somthing like this. This is from an actual batch report:
So using these values
I goto a cell in the report. Click on the conditional formatting for the cell and would type: =OR(E18>'Values for Spec'!C4,E18<'Values for Spec'!B4) With value for spec being the sheet pictured about.
I should note. That if I don't reference a sheet in conditional formating and just -4 instead of "valuesforspecc4" the conditional formatting works. The problem with this is I have 2 sheets that have different specs depending on the test so I can't do that.
Thanks in advance for any input.
Hi Josh, sorry it's taken so long to get back to you. The problem is that when KeyLAB Batch prints it does a copy-paste value of the whole sheet. This doesn't bring things like conditional formation across I'm afraid. I am happy if you want to email me we can run over if there are any other options for what you are needing to do.
Oliver.Carnaby@Bentley.com