RGB color codes?

regwitt · #1 12-17-2014, 06:26 AM

I am trying to embed an IF statement within another IF statement with a condition that would change the color of the cell. I'm aware of macros and really don't think it should be that complicated.

=IF("",RGB(255,0,0),"") WHY NOT!!!!

Is this possible? If so please help.

Thanks in advance.....

excelledsoftware · #2 12-17-2014, 11:30 PM

So are you looking to do this in VBA? if so you need to put some more code in so that your program know what objects to look at. Start with this

Code:

If Range("A1").Interior.ColorIndex = 4 Then
  If Range("A1").value <> "" Then
    msgbox "This cell equals nothing and is green."
  End If
End If

CoolBlue · #3 01-06-2015, 04:51 PM

I can't tell much from your question but if you want to change the colour of a cell using a formula then conditional formatting is what you need.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Color codes as background	Anderso	Excel	1	12-19-2014 11:53 PM
Converting color codes in VBA	Ulodesk	Word VBA	7	11-24-2014 04:15 AM
Is it possible to merge the two VBA codes into just one	sam2149	Excel Programming	0	02-26-2014 05:28 AM
I created a custom XML color scheme. How do I add that to the Built-in Color?	Cassik	PowerPoint	5	11-04-2013 02:08 PM
Codes for Word Textbox Font Color?	tinfanide	Word VBA	7	10-23-2012 03:13 PM