Conditional Formatting multiple values

hi all,

i have a key that has 4 values (MR, PT, CC, HC) each of which have a different colour.

each of my rows will have one of these values (selected by validation list). what i want is to automatically change the colour based on the selected value to the colour in the key?? is this possible through conditional formatting, i.e. if cell value "MR" then colour (green), if cell value "PT" then colour (blue) etc..

i'm trying to avoid vba if poss.

thanks, spin.

In Excel 2007 select your row (the area you want to be coloured based on the value of one cell on that row), then go to Home - Conditional formatting. Go to New Rule - Use a formula to determine which cells to format. Then use the formula

=$A1="MR"
and set the format to colour green

This is assuming the value to evaluate is in the first column

Check that this works, then repeat for your other colours.

thanks deemo,

never realised you could have multiple conditions on a single cell