Thread: Conditional Formating

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: 

If you need more than 3 colors for a cell (plus the default) then
you can not use C.F. alone and you would probably want to use an
Event macro
Another alternative is to use Extended Conditional Formatter Excel addin (up to 50) that you
use exactly like C.F., or to use Excel 2007 which has no limit.

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

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.