if...color
 

What should I do if cell A1 is red color and Cell B1 is not negative, Cell C
will show "Cell B should be negative"
Thank you for your help

if...color
 

Maybe something like this:

With Sheet1
If .Range("A1").Interior.Color = vbRed And
IsNumeric(.Range("B1").Value) And .Range("B1").Value = 0 Then
.Range("C1").Value = "Cell B1 should be negative"
End If
End With


"Anna" wrote in message
...
What should I do if cell A1 is red color and Cell B1 is not negative, Cell
C
will show "Cell B should be negative"
Thank you for your help



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----