HOW CAN I APPLY A COLOR TO ENTIRE ROW USING CONDITIONAL FORMATT

hi,

Not a good idea to highlight all the row unless you have data. If you did then select row 1 go to Data > conditional formatting and enter

=$A1<>""

This will highlight the whole row if there is a entry.

Always enter as $ to make it work

VBA Noob

Since you have elected to provide absolutely no details a guess is all you can
expect.

Select the entire row.

Format>CF>Formula is: =$A$1="hoohah"

Pick a color from Format>Patterns and Ok


Gord Dibben MS Excel MVP

On Sun, 30 Jul 2006 04:11:01 -0700, conditional format <conditional
[email protected]> wrote: