Multiple conditional formats

**Guzziguy** · 08-05-2009, 04:15 PM

I've trawled the fora but can't find a similar thread, so am posting this - apologies if it's a duplicate!

In Excel 2007 I want to apply multiple conditional formats to cellse.g.

If A1 = "A" then <fill cells A2:A12 with red colour>
If A1 = "B" then <fill cells A2:A12 with green colour>
If A1 = "C" then <fill cells A2:A12 with blue colour>

This was easy in Excel 2003 by simply adding a format (to a maximum of 3 formats), but I just can't fathom how to do it in Excel 2007 - all help gratefully received!

Guzziguy

**ChemistB** · 08-05-2009, 04:24 PM

In Excel 2007, from the Home Tab>Conditional Formatting>New Rule >"Use a formula to determine which cells to format" Then this formula

Please Login or Register  to view this content.

and set your formatting. Repeat with your other rules. Does that work for you?

**Guzziguy** · 08-05-2009, 05:33 PM

Thanks ChemistB - that works - it just wasn't obvious because 2007 doesn't show all the rules for a cell, or overtly allow you to add rules whilst seeing existing rules - or at least if it does I can't see how to do it! - thanks again - PROBLEM SOLVED

**martindwilson** · 08-05-2009, 07:41 PM

to view conditional formats, click manage rules then either double click on rule or select one and click edit, or just hover over rule inlft hand pane