Hi VCSGroup

See
http://www.mcgimpsey.com/excel/conditional6.html

And See this Add-in
http://www.xldynamic.com/source/xld.....Download.html


--
Regards Ron de Bruin
http://www.rondebruin.nl


"VCSGroup" wrote in message lkaboutsoftware.com...
I have a spreadsheet that has text information entered from rows 1 to 10
and in clumns A to F. What is the code to look in column A, rows 1-10
for
a text value, if found, shade the entire row from column A to F(Not just
the cell). These cells will be reused on regular basis so I also need to
have the code to remove the shading if text is blank and if text is not
found.