Conditional formating or Macro code
 

Hi,

I need help on setting colors to rows depending on a cell value from
those rows.

I have a sales spreadsheet with 8 sales reps information on it.
Each row has a single invoice.

I want to assign a color to the row cell range depending on the sales
rep code.

For Example.
If on the first in column A I list the sales rep codes like "EM",
"EV", "RP" , etc

If A2 says "EM" I want the cell range A2:H2 to be pink
If A3 says "EV" I want the cell range A3:H3 to be orange

I want to set it up so when I type the sales rep code it will
automatically asign the color to the row range

Thanks in advance

Conditional formating or Macro code
 

You can do this with a Conditional Format if you have 3 or less sales reps.
If more than 3, you'll need to do with with a Worksheet_Change event macro.

This should get you started.

http://www.cpearson.com/excel/cformatting.htm

HTH,
Barb Reinhardt

" wrote:

Hi,

I need help on setting colors to rows depending on a cell value from
those rows.

I have a sales spreadsheet with 8 sales reps information on it.
Each row has a single invoice.

I want to assign a color to the row cell range depending on the sales
rep code.

For Example.
If on the first in column A I list the sales rep codes like "EM",
"EV", "RP" , etc

If A2 says "EM" I want the cell range A2:H2 to be pink
If A3 says "EV" I want the cell range A3:H3 to be orange

I want to set it up so when I type the sales rep code it will
automatically asign the color to the row range

Thanks in advance

Conditional formating or Macro code
 

Thanks,

Does anyone have an example file for more than 3?

Conditional formating or Macro code
 

http://rhdatasolutions.com/ConditionalFormatVBA/

" wrote:

Thanks,

Does anyone have an example file for more than 3?