Conditional formatting rows if one cell is empty only if other cell contains text

[Beezlouise]

Have a sheet with multiple other conditional formatting rules in place that work fine, but I can't seem to get this one to work.

Each row tracks an email so I need the entire row to highlight if something needs to be done. Some emails require they be sent by paper to other parts of the building and I need to enter the date this is done and who they go to.

Simply put, I need the row to highlight if the cell in column M is empty ONLY if the cell in column J has text.

Any help is appreciated!

 

[jtakw]

Hi,

Try:

=AND($M1="",$J1<>"")