Hi Howard,

Am Sun, 26 Apr 2015 08:33:49 -0700 (PDT) schrieb L. Howard:

Is there a boolean expression that will do this?

Cells yellow with an A or not.

try:

Private Sub Worksheet_Change(ByVal Target As Range)
Target.Interior.ColorIndex = IIf(Target = "A", 6, xlNone)
End Sub

If this is not the expected soluntion please post more informations


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional