How do I properly use conditional formatting during the import process?

How do I properly use conditional formatting during the import process?

What is conditional formatting?

Conditional formatting is a feature available on most spreadsheet applications (e.g. Microsoft Excel, Google Sheets) that highlights cells based on certain criteria. In this case, we use conditional formatting to make sure that the email address and date of birth fields are being added using the correct format. For example, if you add 'sample@sample' as the email address using the template, it will highlight the cell in red since it is missing '.com' at the end. This will help you identify any erorrs in your file prior to uploading it on Vome!

How do I use the correct paste option?

If you are planning on copying and pasting email addresses or date of birth fields, you need to ensure that you are using the correct paste option, otherwise conditional formatting will not get applied!

Luckily, it is very simple.

Before pasting an email address or date of birth field on the template:

1. Highlight the cells and right click with your mouse

2. Click on the arrow for Paste Special

3. Then click  Merge Conditional Formatting



    • Related Articles

    • How should I import archived profiles into the database?

      By default, when you import profiles into the database they will be in your Active profiles list. Upon importing new profiles into the database, you can bulk assign profile tags. The best way to streamline the process of moving profiles into your ...

    • How do I prepare my spreadsheet to import into my database?

      First off, it is important to understand that for each import, you can perform Bulk Actions on volunteers listed in the spreadsheet. If you want to assign your volunteer list to different opportunities, tags or shifts during the import process, you ...

    • How do I use a Custom ID field to find and match profiles during the import process?

      *Please note this feature is only available for customers using the Enterprise Plan By default, we find and match profiles using the user's email address. In other words, it is the primary field on Vome. Here is an example to illustrate this. For ...

    • How do I import profile pictures for users in my database?

      Using Vome's import process, you will see that you can import profile images for users in bulk. It is important to note that this feature was designed to help organizations mass import profile images from another software. As such, the way you import ...

    • How do I use Forms on Vome?

      What are the different use cases for creating forms on Vome? Application, Inquiry, Registration: Add many different sections on a form to request profile information, emergency contact, medical information, general availability, question responses in ...