Is there a way to get a cell's text or fill/background color to blink or flash?

[Eloise T]

Is there a way to cause a cell's text or background to blink when the contents of the cell's value becomes equal to any given numeric or text value? In other words, can something like Conditional Formatting be engaged and cause the cell to blink or flash when the cell(s) contains a particular value?

 

[Asheesh]

AFAIK, it is not possible without VBA..

 

[Eloise T]

Does VBA stand for Very Bad Answer? ...and not the one I was hoping for?

Excel needs to have a "suggestion" e-mail box for things like that...as well as adding "CHANGE CASE"

 

[Asheesh]

lol...that is innovative..Knock Knock Microsoft..

 

[bobhc]

CHANGE CASE

Change text to upper, lower, or proper (normal) font
If you need to quickly change the text case to uppercase, lowercase, or proper (normal) case, use Flash Fill instead of retyping all the text.

For example, column A has a list of names in lower case. Here's how you can change the names to proper case.

1. In cell B2 or the column next to your data, type the first and last name with the first letter in each name capitalized and press Enter.
   
   
   
   
   
   
2. Press Ctrl+E, or click Data > Flash Fill.
   
   
   
   
   

Flash Fill automatically fills in the rest of the names in column B, in the proper case.

Inconsistent capitalization? Use functions
Flash Fill works best on consistent data and doesn’t work on text that’s mistyped like this.

With inconsistent text, use functions to change the case of existing text. Since all of the following functions work the same, we’ll see how to use just one of them.

• PROPER function – capitalizes the first letter in each word.
  
  
• UPPER function – changes text to all uppercase.
  
  
• LOWER function – changes text to all lowercase.
  

Change text to proper case with the PROPER function

1. To change Annik’s name to proper case, select cell B1. Type =PROPER(A1), and press Enter.
   
   
   
   
   
   
2. To copy the formula down through cell B5, double-click the green square in the lower-right corner of cell B1.
   

The names in column B are all in proper case.

Get rid of the first column
Just deleting the column of mistyped names might result in formula errors (#REF!). Here's how to remove the column:

1. Copy the names in column B by dragging down the column and pressing Ctrl+C.
   
   
2. Right-click cell A1.
   
   
3. Click Paste Special > Values > OK to paste the names in column A without the formulas.
   
   
4. Select column B.
   
   
5. Right-click the selection, and pick Delete > Entire Column > OK.
   

 

[Eloise T]

CHANGE CASE

Change text to upper, lower, or proper (normal) font
If you need to quickly change the text case to uppercase, lowercase, or proper (normal) case, use Flash Fill instead of retyping all the text.

For example, column A has a list of names in lower case. Here's how you can change the names to proper case.

1. In cell B2 or the column next to your data, type the first and last name with the first letter in each name capitalized and press Enter.
   
   
   
   
   
   
2. Press Ctrl+E, or click Data > Flash Fill.
   
   
   

Flash Fill automatically fills in the rest of the names in column B, in the proper case.

Inconsistent capitalization? Use functions
Flash Fill works best on consistent data and doesn’t work on text that’s mistyped like this.

With inconsistent text, use functions to change the case of existing text. Since all of the following functions work the same, we’ll see how to use just one of them.

• PROPER function – capitalizes the first letter in each word.
  
  
• UPPER function – changes text to all uppercase.
  
  
• LOWER function – changes text to all lowercase.

Change text to proper case with the PROPER function

1. To change Annik’s name to proper case, select cell B1. Type =PROPER(A1), and press Enter.
   
   
   
   
   
   
2. To copy the formula down through cell B5, double-click the green square in the lower-right corner of cell B1.

The names in column B are all in proper case.

Get rid of the first column
Just deleting the column of mistyped names might result in formula errors (#REF!). Here's how to remove the column:

1. Copy the names in column B by dragging down the column and pressing Ctrl+C.
   
   
2. Right-click cell A1.
   
   
3. Click Paste Special > Values > OK to paste the names in column A without the formulas.
   
   
4. Select column B.
   
   
5. Right-click the selection, and pick Delete > Entire Column > OK.

Thank you very much for the detailed answer!

I'm using 2007; I need to upgrade for certain to have Flash Fill!
One of my biggest headaches is converting y to Y, n to N, n/a to N/A, etc. as well as changing names to "proper" every week when people send me their blocks of spreadsheet that I compile into one giant spreadsheet.