| T O P I C R E V I E W |
| imoada |
Posted - 09/30/2014 : 12:16:41 PM
Originpro 9.1.0 SR3
Win7 Ultimate SP1
Hello all
Does anyone know how to make font color of data in worksheet change automatically when data change. For example, when data in a cell in a worksheet change from number 5 to number 3 (or other number), the font color of this cell change from black (default) to green (or other color). If the data in this cell get back to 5, font color of this cell return to black too.
Thanks for any tip. |
| 3 L A T E S T R E P L I E S (Newest First) |
| cpyang |
Posted - 10/09/2014 : 11:38:04 PM
If you just want to visualize the data using color, then just convert the worksheet data to a matrix and view in Image mode.
1. Worksheet menu to choose Direct
2. A new matrix will be created with the data, and you now can go to View menu to choose Image Mode.
3. You can further show the image view in color by using a palette by using Matrix->Apply Palette to Color Map
CP
|
| imoada |
Posted - 10/03/2014 : 02:24:09 AM
hello, greg
Thanks for your reply.
Yes, I think we need a more complicated program to solve this hard question. Maybe need to modify Origin deeply. But this desire is not worh the effort because this function is not widely useful. Nevertheless, thank greg again. |
| greg |
Posted - 10/02/2014 : 3:33:11 PM
In principle you could do something along these lines:
Add a column and use Set Column Values to enter a Before Formula Script...
// Begin script
dataset dsV;
range raD = col(2); // or whatever column you want to 'watch'
vfind ix:=raD value:=3 ox:=dsV;
loop(idx,1,dsV.GetSize())
{
row = dsV[idx];
wcellcolor irng:=raD[row] color:=color(green) type:=1;
}
// End script
I suspect that for what you want to do, the script could get pretty complicated. |
