Row Colour Depending On Drop Down Result

Hi All,

Does anyone know if there is any way to have the colour of a row depending on a result?

For example if i had three columns:

Product, Description and Status

Could i have it so that if the status= active the row would be green and if status=inactive the row would be red?

As i say, i don't even know if this is possible.

Thanks
Chris

Brilliant,

thanks for that - worked great!!

Chris

Is there any way to have more that three conditional formatting options per cell or is that the absoloute max?

That is the max unless you want to start writing macros using VBA.

haha that is def a no go then - i'm bad enough with the plain conditional formatting :P

thanks for the quick reply!