VBA code for Formatting

**karch35** · 03-03-2007, 01:48 PM

I have a spreadsheet with 500 rows. I need the code to look through Column A for up to 10 conditions. For each condition it will color the row a different color.

For example if A1 = Apple, Color the row Red
A1 = Orange, Color the row Orange
A1 = Banana, Color the row Yellow
....... and so on...

Please help

Thanks

**duane** · 03-03-2007, 02:06 PM

here is a suggestion, turn on the macro recorder and color 10 rows the 10 colors you want the stop the recording. Then create a new macro which will be very simple.

For i = 1 to 500 (or whatever your row range is)

if cells(i,1).value ="apple" then cells(i,1).entirerow.Interior.ColorIndex =

whatever colorcode you want

next i

**VBA Noob** · 03-03-2007, 02:13 PM

You may find this link helpful

http://www.excelforum.com/showpost.p...28&postcount=2

VBA Noob

VBA code for Formatting

LinkBack

Thread Tools

Rate This Thread

Display

VBA code for Formatting

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions