Conditional Formatting in Excel 2007 based on Text in another column

[hsshah]

Hello Everyone,

I have a report that has to be sent weekly, then 4 weekly reports convert into a monthly report and then 12 monthly reports convert into 1 yearly report.
Now the problem is that I need to do conditional formatting on a single column based on the Text values that another column contains. Here's the pic and i'll explain it in detail after this

Now in Column N i have detail of the site whether it is microwave or VSAT site. Now the formatting is to be based on this column as follows:

• If column N contains the acronym "VSAT" whether it is VSAT+MW Site or VSAT Site it should color light red the corresponding entry in column D.
• If the acronym "VSAT" is not present then it should color light orange the corresponding entry in column D.

Here's what I did.

• I went to conditional formatting in the Excel 2007 ribbon.
• I chose: New Rule
• I chose: Use a formula to determine which cells to format.
• Then in format values where this formula is true I wrote: =N3="VSAT Site"
• I then set the formatting needed
• Then in Manage rules I chose applies to as : =$D$3:$D$28
• Then I click apply and OK and nothing happened.

Help needed as to what am I doing wrong? This would lessen the amount of work which I have to do substantially.

Thanks in advance

 

[hsshah]

Thanks man for both the Solution and Advice

 

[Peter_SSs]

No problem, glad to help.