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

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=566386

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

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: