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 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 ...
    • I'm a volunteer. How do I use Vome?

      Vome was built to make it easy for volunteers to engage with organizations. More specifically, we want to simply the process for you to: 1. Register for new volunteer opportunities Link: How do I register for an opportunity? 2. Complete screening ...
    • I received a referral code from a Vome partner. How do I use it?

      Here are the steps to use your referral code: Step 1: Sign up your organization to Vome If you need additional help signing up your organization, read this article. Step 2: Add the referral code when completing your organization's profile Once your ...
    • How should I use the organization's page?

      On the profile, there is a share button where you can copy the URL and share it via any communication channel that you use to publish volunteer opportunities (Website, Facebook, LinkedIn, Twitter, Email...etc). Once someone clicks on the link, it ...
    • How do I use Forms on Vome?

      Although you can use forms for surveys or any other data collection purpose from volunteers, they are often used for recruitment. How do volunteers arrive to the form? There would be 3 ways for volunteers to arrive to this form and submit a response: ...