Use conditional formatting.

Select all the rows (let's assume it is E-M in this case).
Go to CF.
Change Condition 1 to Formula Is
Add a formula of =$E5="closed"
Click Format button and format as desired
OK out

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Venkatesh V" wrote in message
...
Hi,
I was to set a particular color to a row based on some condition.

ForEx: if the value of a cell E5 is 'closed', then
set that entire row to 'grey' color.

How do I do that?