Auditing an expense account
You have been asked to perform an internal audit of your company's accounting records.
The miscellaneous expense account has been trending significantly higher and the accounting manager suspects that there may be ficticious transactions recorded.
You have to work efficiently, so you will only look at the more suspicious transactions.
You decide to only look at transactions that were posted outside of normal hours. You also want to look at transactions posted on Saturday or Sunday.
This exercise is part of the course
Conditional Formatting in Google Sheets
Exercise instructions
- Highlight the
Day of the weekdataD5:D33and add one "Text contains" rule that highlights any cell with the Default red background if it contains the wordSAT.- The Default red background can be found by clicking on the Default green background under Formatting style and switching
Green backgroundtoRed background.
- The Default red background can be found by clicking on the Default green background under Formatting style and switching
- Create another rule for the same range that highlights any cell that contains the word
SUNwith the Default red background. - Highlight the
Time of daycolumnE5:E33and add a rule that highlights cells with the Default red background if they contain times that are not between8:00:00 AMand5:00:00 PM.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise