Try something like the following:
If Range("A1").Font.ColorIndex = 3 Then ' red
MsgBox "Red Cell"
End If
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
wrote in message
oups.com...
Is there a way to have an IF statement check a cell and do something
according to the color of the font?