Color whole row when one cell contains any text

[RBarry]

Hi,
I'm looking to set my sheet up so that when I2 contains any text(date in this case) the whole row highlights indicating the package has been sent.
[TABLE="width: 1271"]
<tbody>[TR]
[TD="class: xl68, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]Title 1[/TD]
[TD]Title 2[/TD]
[TD]Title 3[/TD]
[TD]Title 4[/TD]
[TD]Title 5[/TD]
[TD]Title 6[/TD]
[TD]Title 7[/TD]
[TD]Title 8[/TD]
[TD]Date Shipped[/TD]
[TD]Title 10[/TD]
[/TR]
[TR]
[TD]Text1[/TD]
[TD]Text 2[/TD]
[TD]Text3[/TD]
[TD]Text4[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]etc[/TD]
[TD]15/07/14[/TD]
[TD]etc[/TD]
[/TR]
</tbody>[/TABLE]

Can anybody help?

 

[pjmorris]

Hi,

You need to use Conditional Formating. Click in the top left hand corner of the range you are interested in then drag down to the bottom right hand corner. On the Home Ribbon click 'Conditional Formating' select 'New Rule' then 'Use a formula to determine which cells to format', enter this code in the 'Format Values Where this formula is true' box: =$I2<>"" then set the format box as you wish and click Apply.

Hope this helps.

Regards

 

[RBarry]

Sorry for the delayed reply. Thank you so much that is exactly what I was looking for.

 

[pjmorris]

No problem, glad I was able to help and thanks for the feedback.

Welcome to the forum.

Regards