# 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%2FOFiaDGOsZGDJokpJLgDy%2Fimage.png?alt=media&#x26;token=5a5593ea-dc06-4e1f-a534-87342ea4ee3c" 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%2FfA3ngldxHybQ7PEoFryb%2Fimage.png?alt=media&#x26;token=1dd9989d-357f-4c18-92e0-3f195e0fd2f2" alt=""><figcaption><p>Selecting the field to drive the colors</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%2FK9PgwyPujUn1kKTlAQ4a%2Fimage.png?alt=media&#x26;token=564ffcbf-747d-470e-bfca-d025a2806fb6" alt=""><figcaption><p>Font color updated based on source data</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%2F5YivNYOz1k7mqr2N0Gct%2Fimage.png?alt=media&#x26;token=8a1d11ea-195b-40c7-904b-e4b3274b3821" alt=""><figcaption><p>Applying a background color based on 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%2FFwrzN6oom8qUF32Zdaew%2Fimage.png?alt=media&#x26;token=79fd1277-d94f-4f45-96ce-cc2aeddde18a" alt=""><figcaption><p>Setting a custom font color</p></figcaption></figure>
