Since you have elected to provide absolutely no details a guess is all you can
expect.
Select the entire row.
FormatCFFormula is: =$A$1="hoohah"
Pick a color from FormatPatterns and Ok
Gord Dibben MS Excel MVP
On Sun, 30 Jul 2006 04:11:01 -0700, conditional format <conditional
wrote: