conditional formatting in excel 2007

[RFarrington]

Good morning all, i have a spreadsheet with 12 columns, 2 of the columns are "responsible party" and "outage in minutes". Based upon the number of outage minutes IE> 240, i have the rule set up to format the entire row in red. Here's my issue, in the responsible party column of data, if the cell reads customer, i do even though the outage minutes is greater than 240, i do not wan the row to be colored in red. Hope this makes sense, any help would be appreciated.

 

[Andrew Poulsom]

You haven't given column references, but if they are A and B, for row 2 try the conditional formatting formula:

=AND($A2<>"customer",$B2>240)

 

[RFarrington]

worked beautifully, ty for your help.....................