Conditional Formating

**bhodo** · 01-06-2010, 11:12 AM

I already have conditional formating set up on my spreadsheet whereby if column "M" states "Bound" then the text in the entire row goes blue and if it states "Lapsed" then it goes Red.

On the same sheet, I have a drop down box containing 4 names. Is it possible to change the background of each row depending on the name? Is there an alternative to conditional formating? I also only want the rows A-Z to change colour is this possible?

**rwgrietveld** · 01-06-2010, 11:21 AM

So the CF is already on ALL cells depending on the value in M?

If you would like to add 4 additional CF's then we have to know what excel version you have?

Version <=2003 have a limit of 3 (with the default makes 4)

Cell formattion allowes you to use additional formatting of the TEXT (RED, BLUE, Etc.)

HTML Code:

here you'll find >1.000.000 examples http://www.mvps.org/dmcritchie/excel/condfmt.htm

**ChemistB** · 01-06-2010, 11:22 AM

It would be best if you posted an example spreadsheet. Especially as I am not sure if you are referring to columns or rows (e.g. "rows A-Z").

I also only want the rows A-Z to change colour is this possible?

Yes, just place the conditional formatting in the rows/columns that you want to change color.

Is it possible to change the background of each row depending on the name?

Excel 2003 has a limit of 3 conditional formatting options within each cell. If you it's okay for two of the names to share a formatting (e.g. if Bob or Bill, then blue), then you can do it OR, if one of the options is no conditional formatting (e.g. if Bob, no change in formatting). Otherwise, it will take VBA to implement additional formatting.

**bhodo** · 01-07-2010, 05:19 AM

Thanks for the post,

I currently have two conditions in column "M" which apply to the entire row. I want to add three other conditions depending on the content of column H that will also apply to the entire row.

I am using Excel 2003 so am I safe to assume that this is not possible?

**bhodo** · 01-07-2010, 06:39 AM

You will have to forgive me as I am a novice to this. But what is VBA and how is this done?

Secondly I would not know where to start with creating an Event Macro? Any advise?

To put it simply, I need to show the following:

If any cell in column H contains:

"Owen" then the background of the row becomes orange
"Ben" the background of the row becomes pink
"Cindy" the background of the row becomes purple
"Emma" the background of the row becomes blue