HI,
The below solutionh was enouigh to set for a single row.
I selected some 5 rows and try to "Paste Special" with only the FOrmats of
that row. It didnt work.
"Bob Phillips" wrote:
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?
|