Find a particular colour in a field
This has to be so simple that I'm just overlooking it. My database has a field called Product Number that lists various products by a unique number. I set up a script button (photo) that changes the colour of the number to red if that product needs to be photographed. Now all I want to do is isolate one color and keep them (red) or delete them (black). Sounds simple but I can't find the right method.
Any ideas would be appreciated. Thanks.