# Field value

You can assign fields from your dataset and apply conditional formatting based on the specified color. Let's consider a Benchmark dataset - each benchmark is represented by a designated color which is part of the source data.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F0LR9atxzDb5vThBTaP5W%2Fimage.png?alt=media&#x26;token=0daa5932-193d-4bf0-86df-9575d103d1b9" alt=""><figcaption><p>Dataset with colors assigned</p></figcaption></figure>

Let's look at how to setup conditional formatting based on a field from your data source.

Assign the text column containing the color scheme to the Writeback Matrix visual. You'll see a **Field value** option in the **Format by** dropdown.

Select the text field that will be used to assign colors from the **Based on** dropdown.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FNgvRiq0o7YYE9aR9kDcY%2Fimage.png?alt=media&#x26;token=8871a2bc-4677-4679-9aac-7f5f8d4d750c" alt=""><figcaption><p>Select the field that will be used to drive the color scheme</p></figcaption></figure>

**Format font color**

The font color for the Actuals measure is changed based on the Benchmark indentifier text field. To apply conditioinal formatting on the font color, select the **Font** option from the **Color for** dropdown.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F2lxjisjXKFgIvqmuyLqY%2Fimage.png?alt=media&#x26;token=4fea1d09-11c9-43dc-a487-4292c2d0d96a" alt=""><figcaption><p>Set the font color from the data source</p></figcaption></figure>

**Format background color**

To change the cell background color select **Background** from the **Color for** dropdown.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2F0lzxI3Y9MMop1TkxXltP%2Fimage.png?alt=media&#x26;token=09f279cd-5619-4961-baca-2db420564166" alt=""><figcaption><p>Apply cell background color from a source field</p></figcaption></figure>

**Using Auto font color**

When the **Auto font color** option is checked, Inforiver assigns a font color which will have maximum visibility against the backgroun color.

Uncheck this option to assign a custom font color from the **Format** menu.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2Fu1vKPqGuP6kwAftjE3tc%2Fimage.png?alt=media&#x26;token=b9166207-9114-4deb-aac8-5fe789f842aa" alt=""><figcaption><p>Custom font color</p></figcaption></figure>
