Submitted by jsolka on 2010/03/09 14:40
What should I put in filter box to filter by font color red?
Thanks
Jay

Comments

Check the value in the ItemForeColor field. An Olive item will have "&H8080"
 
so you can filter by entering ItemForeColor="&H8080"
 
Same for ItemColor (back color), except that it also supports named colors
 
The filter can be entered :
  1. on the source bar, or [EDIT] in the Filter textbox of the source bar (Alt-S) [/EDIT]
  2. using the Alpha toolbar
  3. in live-search (Ctrl+F), simply type &H8080 and your Olive items will show up (perhaps with some other items, as it searches all text fields)
 
HTH
 

jsolka

2010/03/10 10:22

In reply to by Pierre_Admin

Thanks. Where and I check item color value?
Why can't I use "Filter Box"? The problem with source bar is that I tend to forget the original source and then it takes time to restore my grid.
Take care,
Jay

Armando

2010/03/10 10:28

In reply to by jsolka

[quote=jsolka]
Thanks. Where and I check item color value?
Why can't I use "Filter Box"? The problem with source bar is that I tend to forget the original source and then it takes time to restore my grid.
Take care,
Jay
[/quote]
 
ON the source bar (alt-s) : you have 1- the source text box, 2- the filter text box, 3-  and the sort text box.
 
You should use the filter text box. It's easy to recover your previous setting as there's a drop down list of all previous filters used. (You can erase the ones you don,t want to appear there by right clicking on them and press delete).
 
Or as Pierre said, use the quick search dialog or the apha numeric toolbar, etc.

jsolka

2010/03/10 10:31

In reply to by Armando

Hi, Armando,
Sorry but you misunderstood -- I was asking where can i find color values, and saying that I CAN'T use the filter text box (I tried), and I was asking why can't I?
 
Thanks,
Jay

Tom

2010/03/10 10:45

In reply to by jsolka

[quote=jsolka]
 I CAN'T use the filter text box (I tried), and I was asking why can't I?
[/quote]
 
Jay, what do you mean by 'you can't'  - more info please, thanks
 
 
 
> where can i find color values
 
[quote=Pierre_Admin]
Check the value in the ItemForeColor field. An Olive item will have "&H8080"
 [/quote]
 
Select the item and check in Properties Pane under 'Filled Fields'

jsolka

2010/03/10 11:15

In reply to by Tom

It works now -- I had the wrong value that I thought was right. Thank you Tom. And thanks Armando -- it was me who misunderstood.
 
Take care,
Jay