Excel 2007 : Conditional Format a row based on multiple conditions

[milliemoo]

Hello, I need some help with CF formula to highlight rows based on several conditions.

I need to highlight a row if the cell in column T is NOT BLANK and the corresponding cell in column Y is blank.

I'm struggling to write the formula to include both of these conditions. Please can you help?

[daddylonglegs]

For row 2 select the whole row (or the part of it you want formatted) and use this formula

=AND($T2<>"",$Y2="")

[milliemoo]

thank you (AGAIN!) daddylonglegs! It works for this row but when I copy/paste format to other rows, it isn't working correctly....is there a way I can write it to be applied to the whole spreadsheet?

[milliemoo]

Oh, please ignore me! It works perfectly! Thank you!