Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
change fill color of a range of cells based on color of a cell? | Excel Programming | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
Browse Forms Controls and change TextBox color based on cell color | Excel Programming |