conditional formatting on a entire row

**Shadmani** · 09-24-2009, 10:14 AM

Hi,

By fullfiling the condition on a cell, is it possible to highlight the entire row related to that cell ?

Thanks
Mani

**rwgrietveld** · 09-24-2009, 10:25 AM

Select the entire Column and in the cf put something like:

=if($D$2<>"",1,0) and it should work

**sweep** · 09-24-2009, 10:27 AM

Select rows 1:whatever, making A1 the active cell
Go to Format > Conditional Formatting
Specify Condition 1 as "Formula Is" using the expression, =$A1=......,
Specify formatting.

**Shadmani** · 09-25-2009, 01:00 AM

Hi.

Thanks to both of you for trying for me.
I am not clear with your reply.
I have enclosed the test file.
Basically, I need to highlight the entire row, if the lead time ( Column X )
is 45 days.

Great, if you could help me...

Regards
Mani

**Shadmani** · 09-25-2009, 01:17 AM

Sorry.. My attachment....

**sweep** · 09-25-2009, 03:26 AM

Select rows 2:28

Go to Format > Contitional Formatting

Where it says "Condition 1" select "Formula is" and enter

=$X2=45

into the box, then select a format