How to invert the coloring scheme in "Color Scale" quick analysis?

Question

I have a datable with n number of rows/columns. I would like to filter the rows based on a column which has only one character value as "*". My version is C#2.0. How to filter the rows and copy into a new datatable.

This code is not working;

DataTable result = dt.Select("FLAG= '*'");

Solution

Quick analysis only helps to quickly create a visualisation. After that, you can select the formatted data and use the Conditional formatting dialog to select another color scale.

Comments

[Osceria]

the filter criteria is column with only value as "*" in the cell

[Ilia Maskov]

Can't reproduce that actually dotnetfiddle.net/SwIvlk

[Osceria]

Updated the code in dotnetfiddle.net/SwIvlk it throws error now

[Ilia Maskov]

i don’t see your changes, you must press share button to apply them.

[Osceria]

dotnetfiddle.net/1L1iZA Please find the updated code here

[James Russell]

I see! I was looking all over for a place to change the formatting and couldn't find it. Thank you very much.