IF statement to control formatting?

**drdavidge** · 01-24-2008, 01:36 PM

Hi, does anyone know if there is any way to use an IF statement to change formatting on a cell? I do not want to use conditional formatting because there are a lot more than 3 possibilities with what I am working with.

For example...I want to basically do this:

-----A-----B-----C--
1---- ----- ------ --
2---- ----- ------ --
3---- -----5-----7--

In A1 I would like to put something like.. =IF(A3=="",set A1 to blank and do not copy formatting,otherwise set A1 to A3 and DO copy formatting) and be able to drag this across the whole Row 1.

**VBA Noob** · 01-24-2008, 02:12 PM

Post a sample file with an example

VBA Noob

**drdavidge** · 01-24-2008, 03:16 PM

not sure how to post xls file on here soo..

http://www.mediafire.com/?1pdxc1ybtgn

oh wait i got it haha

**VBA Noob** · 01-24-2008, 03:45 PM

Try click the sheet tab > select view code > paste in the below

Please Login or Register  to view this content.

VBA Noob

**drdavidge** · 01-24-2008, 04:20 PM

Wow.. that is awesome. I didnt even know you can put code on sheets.

Now.. I have about 20 ranges where I want this to work.. can I just ammend this line to include them all like so..?

Please Login or Register  to view this content.

etc?

**VBA Noob** · 01-24-2008, 04:50 PM

Please remember to wrap your code next time as per forum rules below

Try

Please Login or Register  to view this content.

VBA Noob

**drdavidge** · 01-24-2008, 05:18 PM

Great.. thank you very much - this is going to save me a ton of time.

IF statement to control formatting?

LinkBack

Thread Tools

Rate This Thread

Display

IF statement to control formatting?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions