You will get an error if Flash Fill cannot find the pattern. The first thing to check is that you're using Flash Fill close to the source data (e.g., in the adjacent cell). For instance, it won't work ...

Snow isn't always white; algae can make it look green, red, or orange, and scientists are trying to understand how and why these colorful patches appear.

Jeff Carlson writes about mobile technology for CNET. He is also the author of dozens of how-to books covering a wide spectrum ranging from Apple devices and cameras to photo editing software and ...