First off, I have used the help function in Excel, searched on Google, and put this in a macro to find the language and I still can't figure it out. So if that is your suggestion, just click the back button or eat a dick. The previous suggestion also applies to anyone who would like to take this opportunity to call me a noob, or any other really cool names you can think of.

What I need is an If statement that will put either a black or red border on the cell depending on whether there is text or not. It would follow the following format, except not in baby terms (obviously):

If(IsText(A2), Bordercolor=black, Bordercolor=red))

So if there is text, I want a black border, if there is no text, I want a red border. And by border I mean a full outline around the cell.

2/16/2007 12:54:24 PM

look up conditional formatting

[Edited on February 16, 2007 at 1:09 PM. Reason : n00b]

2/16/2007 1:07:56 PM

Quote :

"just click the back button or eat a dick."

that's not very nice.

2/16/2007 1:10:12 PM

i know right. and after all we've done for you

2/16/2007 1:13:08 PM

Well past topics and observations have made made me automatically defensive...technically it's all your guys' fault

but anyways thank you qntmfred

[Edited on February 16, 2007 at 1:38 PM. Reason : a]

2/16/2007 1:17:51 PM

fo sho

2/16/2007 1:44:06 PM

You'll get shit on no matter how you ask your question. Thus, you might as well be nice about it. By the way, did you have any luck with the conditional formatting?

2/16/2007 4:42:37 PM

if you can write Perl...

look up OLE::Automation.



(yeah, I guess VB Script does the same thing more directly. but i dont do VB. meh.)






[Edited on February 16, 2007 at 6:06 PM. Reason : vb]

2/16/2007 6:05:14 PM

vba can do it, however you really only need conditional formatting for this

2/17/2007 12:02:37 PM

no shit. this is exactly what conditional formatting is for, and it will take about 15 seconds to do.

don't even think about getting scripting involved.

2/17/2007 12:03:33 PM

well. i guess its "conditional formatting" FTW.

i love this forum. i need to come here more.

2/17/2007 6:16:15 PM

yeah conditional formatting worked no problem, exactly what I needed...thanks

I actually had to put it into a script so I just started recording a new macro, applied the formatting, and then copied and pasted for what I needed

2/17/2007 7:17:56 PM