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

V

VBA Noob

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
 
G

Gord Dibben

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
 
Top