Conditional Formating in order highlight entre row

[harinsh]

Hi,

Please help in order to perform conditional formatting for entire row, if one condition satisfy for particular Cell then entire row should get highlighted.

Thanks,
Harish Kumar

 

[VoG]

See if this helps http://www.contextures.com/xlCondFormat02.html

 

[harinsh]

Thanks VoG for your link.

But still I am not able to get the format in Excel2007. Please help in order to get the same.

Regards,
Harish Kumar

 

[harinsh]

Hello Guys,

Can you please any one help me with this requirement.

Many thanks,

 

[RonB1111]

Select your data, eg: A2:N1000
Click Data-Conditional Formatting - New Rules
Select "Use a formula ..."
If your condition is, say, the value in column G equals 100, enter this formula in the formula box and then format as desired:
=$G2=100
Notice that I used the 2nd row in G2 because that was the 1st row of data selected above, ie A2:N1000. You also need to put a $ in front of G2 so the rule doesn't move across columns.

 

[harinsh]

Hi RonB1111,

Thanks for your reply.

Yes, Now I can see the desired output.

Thanks