ESdat Forums
»
Forums
»
ESdat
»
Highlighting Non-Detect Exceedances
 Rank: Advanced Member
Groups: Registered
Posts: 78
Thanks: 1 times
|
Hello,
We noticed that you can highlight non-detects that exceed a standard with a different colour in the default output setup:
But we are not aware of a way to replicate this in the output table once we’ve changed the colours of one or all of the standards. Is there a way to highlight the DL exceedances with a separate colour/format in output tables post-production?
Thanks,
Dave
|
|
|
|
|
|
 Rank: Administration
Groups: Registered, Administrators Posts: 329  Was thanked: 29 time(s) in 29 post(s)
|
Hi Dave,
You can't replicate the format applying different fill coloring once you've started using the Excel formatting toolbox.
However, you can use different font colors to achieve a similar effect.
The process doesn't actually require setting the font color or fill color for non-detects in the options box, however I have set this with some vibrant colors to demonstrate the process in Excel a bit more obviously.
1. Export your chem table to Excel. Your default output will look like this using the settings above (note the different formatting for the ND exceedance):
2. Apply Fill Color formatting ensuring that "incl Non-Detects" is not selected:
You will see that this applies the Fill Color, but does not modify the font color.
3. Apply Font Color, ensuring that "Incl Non-Detects" is selected. This will then create different formatting for the NDs.
I hope this helps!
Nick
|
|
|
|
|
|
ESdat Forums
»
Forums
»
ESdat
»
Highlighting Non-Detect Exceedances
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.