• We are pleased to announce that the winner of our Feedback Prize Draw for the Winter 2024-25 session and winning £150 of gift vouchers is Zhao Liang Tay. Congratulations to Zhao Liang. If you fancy winning £150 worth of gift vouchers (from a major UK store) for the Summer 2025 exam sitting for just a few minutes of your time throughout the session, please see our website at https://www.acted.co.uk/further-info.html?pat=feedback#feedback-prize for more information on how you can make sure your name is included in the draw at the end of the session.
  • Please be advised that the SP1, SP5 and SP7 X1 deadline is the 14th July and not the 17th June as first stated. Please accept out apologies for any confusion caused.

Conditional Formatting

M

madame_actuary

Member
When doing the data checks, I normally have a formula that shows Error or Ok. I also usually use conditional formatting to highlight the error cells.

Can i also do this for the CA2, and highlight that i used conditional formatting it in the audit trail maybe?
 
I think in addition you'll need a comment somewhere to say what the check is, probably in the audit trail.
 
No reason why you can't do this, although I'd generally be wary of spending too much time on fancy bells-and-whistles formatting.

First rule of clarity is: keep it simple. The examiner is more concerned with the fact that:
- you've put a check in
- you've noted in the audit trail that the check is there
- the check is clearly visible on the sheet, and it's clear what it's checking.

Having a bunch of fancy red & green OK and ERROR cells is pointless if it's not clear what they're checking. Focus first on getting the message across well. If you have time at the end, then go ahead and make it pretty.
 
Back
Top