Highlight a cell in a specific row

SL - Jul 16, 2010 at 01:58 PM
 SL - Jul 21, 2010 at 05:43 PM

I would like to know if anyone knows how to write a Visual Basic script that I could run that will highlight the cell(s) in a color if they do not have have four capital alpha and four numeric. Basically all cells in that row should be CFSF7464.

Please help :)

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 16, 2010 at 06:36 PM
If the cell would be in this format


you can use conditional format using this formula

Thank you this worked perfectly!